{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Work Orders","Parcels","Relo Schedule Phase 1","Relo Schedule Phase 2","Example Parcels","Example","Appendix","Guidance"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":5,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Work Orders","index":0,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":true,"merged":[[6,0,8,0],[6,1,8,1],[6,2,8,2],[0,0,0,17],[1,3,1,12],[2,0,4,0],[2,1,4,1],[2,2,4,2]]}
["TIP No. X-XXXX Utility Priority Parcels"]
["Duke Work Order","UbO Sheet","Station Range",null,null,null,null,null,null,null,null,null,null,null,"Acquired","Total","% Complete"]
[1,"UO-2 - UO-8","10+00 - 100+00",2,5,6,12,13,14,15,16,17,18]
[null,null,null,19,23,24,25,26,27,28,29,30,31,null,26,27,{"$f":"O4/P4","v":0.96296296296296291},null,null,"Waiting to be recorded"]
[null,null,null,32,33,34,35,38,72,73,null,null,null,null,null,null,null,null,null,"Initial Contact"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Hold"]
[2,"UO-9 - UO-15","100+00 - 162+00",40,41,42,43,44,45,46,47,48,49,null,null,null,null,null,null,"Condemnation"]
[null,null,null,50,51,54,55,56,57,58,63,64,66,null,24,28,{"$f":"O8/P8","v":0.8571428571428571},null,null,"Filed"]
[null,null,null,67,68,69,70,71,74,75,77]

{"sheet":"Parcels","index":1,"n_rows":1010,"n_cols":32,"rows_kept":1010,"cut":false,"hidden":false,"merged":[[14,0,15,3],[7,5,7,8]]}
["Legend",null,"Acquired",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acquired","Hidden"]
[null,null,"Waiting to be recorded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting to be recorded"]
[null,null,"Initial Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Contact"]
[null,null,"On Hold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Hold"]
[null,null,"Condemnation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condemnation"]
[null,null,"Filed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filed"]
[null,null,null,null,null,"Replace \"Utility Owner #\" with actual Utility Owner names"]
["Acquired","Total","% of Parcels Acquired","Acquired Date",null,"If Utility owner is on parcel select them from dropdown"]
[{"$f":"COUNTIF(G11:G1010, \"Acquired\")+COUNTIF(G11:G1010, \"Filed\")","v":0},{"$f":"SUMPRODUCT(--(MMULT(--(I11:X1010<>\"\"),TRANSPOSE(COLUMN(I11:X11)^0))>0))","v":0},{"$f":"IF(B9=0,\"\",A9/B9)","v":""}]
[null,null,null,null,null,"Date Acquired","Status","Parcel #","Utility Owner 1","Utility owner 2","Utility owner 3","Utility owner 4","Utility owner 5","Utility owner 6","Utility owner 7","Utility owner 8","Utility owner 9","Utility owner 10","Utility owner 11","Utility owner 12","Utility owner 13","Utility owner 14","Utility owner 15","Backflow Preventer"]
[null,"V2.0",null,null,null,null,null,"Parcel 001"]
[null,null,null,null,null,null,null,"Parcel 002"]
[null,null,null,null,null,null,null,"Parcel 003"]
[null,null,null,null,null,null,null,"Parcel 004"]
["To use buttons you must have the file saved to your trusted file location, instruction on help sheet",null,null,null,null,null,null,"Parcel 005"]
[null,null,null,null,null,null,null,"Parcel 006"]
[null,null,null,null,null,null,null,"Parcel 007"]
[null,null,null,null,null,null,null,"Parcel 008"]
[null,null,null,null,null,null,null,"Parcel 009"]
[null,null,null,null,null,null,null,"Parcel 010"]
[null,null,null,null,null,null,null,"Parcel 011"]
[null,null,null,null,null,null,null,"Parcel 012"]
[null,null,null,null,null,null,null,"Parcel 013"]
[null,null,null,null,null,null,null,"Parcel 014"]
[null,null,null,null,null,null,null,"Parcel 015"]
[null,null,null,null,null,null,null,"Parcel 016"]
[null,null,null,null,null,null,null,"Parcel 017"]
[null,null,null,null,null,null,null,"Parcel 018"]
[null,null,null,null,null,null,null,"Parcel 019"]
[null,null,null,null,null,null,null,"Parcel 020"]
[null,null,null,null,null,null,null,"Parcel 021"]
[null,null,null,null,null,null,null,"Parcel 022"]
[null,null,null,null,null,null,null,"Parcel 023"]
[null,null,null,null,null,null,null,"Parcel 024"]
[null,null,null,null,null,null,null,"Parcel 025"]
[null,null,null,null,null,null,null,"Parcel 026"]
[null,null,null,null,null,null,null,"Parcel 027"]
[null,null,null,null,null,null,null,"Parcel 028"]
[null,null,null,null,null,null,null,"Parcel 029"]
[null,null,null,null,null,null,null,"Parcel 030"]
[null,null,null,null,null,null,null,"Parcel 031"]
[null,null,null,null,null,null,null,"Parcel 032"]
[null,null,null,null,null,null,null,"Parcel 033"]
[null,null,null,null,null,null,null,"Parcel 034"]
[null,null,null,null,null,null,null,"Parcel 035"]
[null,null,null,null,null,null,null,"Parcel 036"]
[null,null,null,null,null,null,null,"Parcel 037"]
[null,null,null,null,null,null,null,"Parcel 038"]
[null,null,null,null,null,null,null,"Parcel 039"]
[null,null,null,null,null,null,null,"Parcel 040"]
[null,null,null,null,null,null,null,"Parcel 041"]
[null,null,null,null,null,null,null,"Parcel 042"]
[null,null,null,null,null,null,null,"Parcel 043"]
[null,null,null,null,null,null,null,"Parcel 044"]
[null,null,null,null,null,null,null,"Parcel 045"]
[null,null,null,null,null,null,null,"Parcel 046"]
[null,null,null,null,null,null,null,"Parcel 047"]
[null,null,null,null,null,null,null,"Parcel 048"]
[null,null,null,null,null,null,null,"Parcel 049"]
[null,null,null,null,null,null,null,"Parcel 050"]
[null,null,null,null,null,null,null,"Parcel 051"]
[null,null,null,null,null,null,null,"Parcel 052"]
[null,null,null,null,null,null,null,"Parcel 053"]
[null,null,null,null,null,null,null,"Parcel 054"]
[null,null,null,null,null,null,null,"Parcel 055"]
[null,null,null,null,null,null,null,"Parcel 056"]
[null,null,null,null,null,null,null,"Parcel 057"]
[null,null,null,null,null,null,null,"Parcel 058"]
[null,null,null,null,null,null,null,"Parcel 059"]
[null,null,null,null,null,null,null,"Parcel 060"]
[null,null,null,null,null,null,null,"Parcel 061"]
[null,null,null,null,null,null,null,"Parcel 062"]
[null,null,null,null,null,null,null,"Parcel 063"]
[null,null,null,null,null,null,null,"Parcel 064"]
[null,null,null,null,null,null,null,"Parcel 065"]
[null,null,null,null,null,null,null,"Parcel 066"]
[null,null,null,null,null,null,null,"Parcel 067"]
[null,null,null,null,null,null,null,"Parcel 068"]
[null,null,null,null,null,null,null,"Parcel 069"]
[null,null,null,null,null,null,null,"Parcel 070"]
[null,null,null,null,null,null,null,"Parcel 071"]
[null,null,null,null,null,null,null,"Parcel 072"]
[null,null,null,null,null,null,null,"Parcel 073"]
[null,null,null,null,null,null,null,"Parcel 074"]
[null,null,null,null,null,null,null,"Parcel 075"]
[null,null,null,null,null,null,null,"Parcel 076"]
[null,null,null,null,null,null,null,"Parcel 077"]
[null,null,null,null,null,null,null,"Parcel 078"]
[null,null,null,null,null,null,null,"Parcel 079"]
[null,null,null,null,null,null,null,"Parcel 080"]
[null,null,null,null,null,null,null,"Parcel 081"]
[null,null,null,null,null,null,null,"Parcel 082"]
[null,null,null,null,null,null,null,"Parcel 083"]
[null,null,null,null,null,null,null,"Parcel 084"]
[null,null,null,null,null,null,null,"Parcel 085"]
[null,null,null,null,null,null,null,"Parcel 086"]
[null,null,null,null,null,null,null,"Parcel 087"]
[null,null,null,null,null,null,null,"Parcel 088"]
[null,null,null,null,null,null,null,"Parcel 089"]
[null,null,null,null,null,null,null,"Parcel 090"]
[null,null,null,null,null,null,null,"Parcel 091"]
[null,null,null,null,null,null,null,"Parcel 092"]
[null,null,null,null,null,null,null,"Parcel 093"]
[null,null,null,null,null,null,null,"Parcel 094"]
[null,null,null,null,null,null,null,"Parcel 095"]
[null,null,null,null,null,null,null,"Parcel 096"]
[null,null,null,null,null,null,null,"Parcel 097"]
[null,null,null,null,null,null,null,"Parcel 098"]
[null,null,null,null,null,null,null,"Parcel 099"]
[null,null,null,null,null,null,null,"Parcel 100"]
[null,null,null,null,null,null,null,"Parcel 101"]
[null,null,null,null,null,null,null,"Parcel 102"]
[null,null,null,null,null,null,null,"Parcel 103"]
[null,null,null,null,null,null,null,"Parcel 104"]
[null,null,null,null,null,null,null,"Parcel 105"]
[null,null,null,null,null,null,null,"Parcel 106"]
[null,null,null,null,null,null,null,"Parcel 107"]
[null,null,null,null,null,null,null,"Parcel 108"]
[null,null,null,null,null,null,null,"Parcel 109"]
[null,null,null,null,null,null,null,"Parcel 110"]
[null,null,null,null,null,null,null,"Parcel 111"]
[null,null,null,null,null,null,null,"Parcel 112"]
[null,null,null,null,null,null,null,"Parcel 113"]
[null,null,null,null,null,null,null,"Parcel 114"]
[null,null,null,null,null,null,null,"Parcel 115"]
[null,null,null,null,null,null,null,"Parcel 116"]
[null,null,null,null,null,null,null,"Parcel 117"]
[null,null,null,null,null,null,null,"Parcel 118"]
[null,null,null,null,null,null,null,"Parcel 119"]
[null,null,null,null,null,null,null,"Parcel 120"]
[null,null,null,null,null,null,null,"Parcel 121"]
[null,null,null,null,null,null,null,"Parcel 122"]
[null,null,null,null,null,null,null,"Parcel 123"]
[null,null,null,null,null,null,null,"Parcel 124"]
[null,null,null,null,null,null,null,"Parcel 125"]
[null,null,null,null,null,null,null,"Parcel 126"]
[null,null,null,null,null,null,null,"Parcel 127"]
[null,null,null,null,null,null,null,"Parcel 128"]
[null,null,null,null,null,null,null,"Parcel 129"]
[null,null,null,null,null,null,null,"Parcel 130"]
[null,null,null,null,null,null,null,"Parcel 131"]
[null,null,null,null,null,null,null,"Parcel 132"]
[null,null,null,null,null,null,null,"Parcel 133"]
[null,null,null,null,null,null,null,"Parcel 134"]
[null,null,null,null,null,null,null,"Parcel 135"]
[null,null,null,null,null,null,null,"Parcel 136"]
[null,null,null,null,null,null,null,"Parcel 137"]
[null,null,null,null,null,null,null,"Parcel 138"]
[null,null,null,null,null,null,null,"Parcel 139"]
[null,null,null,null,null,null,null,"Parcel 140"]
[null,null,null,null,null,null,null,"Parcel 141"]
[null,null,null,null,null,null,null,"Parcel 142"]
[null,null,null,null,null,null,null,"Parcel 143"]
[null,null,null,null,null,null,null,"Parcel 144"]
[null,null,null,null,null,null,null,"Parcel 145"]
[null,null,null,null,null,null,null,"Parcel 146"]
[null,null,null,null,null,null,null,"Parcel 147"]
[null,null,null,null,null,null,null,"Parcel 148"]
[null,null,null,null,null,null,null,"Parcel 149"]
[null,null,null,null,null,null,null,"Parcel 150"]
[null,null,null,null,null,null,null,"Parcel 151"]
[null,null,null,null,null,null,null,"Parcel 152"]
[null,null,null,null,null,null,null,"Parcel 153"]
[null,null,null,null,null,null,null,"Parcel 154"]
[null,null,null,null,null,null,null,"Parcel 155"]
[null,null,null,null,null,null,null,"Parcel 156"]
[null,null,null,null,null,null,null,"Parcel 157"]
[null,null,null,null,null,null,null,"Parcel 158"]
[null,null,null,null,null,null,null,"Parcel 159"]
[null,null,null,null,null,null,null,"Parcel 160"]
[null,null,null,null,null,null,null,"Parcel 161"]
[null,null,null,null,null,null,null,"Parcel 162"]
[null,null,null,null,null,null,null,"Parcel 163"]
[null,null,null,null,null,null,null,"Parcel 164"]
[null,null,null,null,null,null,null,"Parcel 165"]
[null,null,null,null,null,null,null,"Parcel 166"]
[null,null,null,null,null,null,null,"Parcel 167"]
[null,null,null,null,null,null,null,"Parcel 168"]
[null,null,null,null,null,null,null,"Parcel 169"]
[null,null,null,null,null,null,null,"Parcel 170"]
[null,null,null,null,null,null,null,"Parcel 171"]
[null,null,null,null,null,null,null,"Parcel 172"]
[null,null,null,null,null,null,null,"Parcel 173"]
[null,null,null,null,null,null,null,"Parcel 174"]
[null,null,null,null,null,null,null,"Parcel 175"]
[null,null,null,null,null,null,null,"Parcel 176"]
[null,null,null,null,null,null,null,"Parcel 177"]
[null,null,null,null,null,null,null,"Parcel 178"]
[null,null,null,null,null,null,null,"Parcel 179"]
[null,null,null,null,null,null,null,"Parcel 180"]
[null,null,null,null,null,null,null,"Parcel 181"]
[null,null,null,null,null,null,null,"Parcel 182"]
[null,null,null,null,null,null,null,"Parcel 183"]
[null,null,null,null,null,null,null,"Parcel 184"]
[null,null,null,null,null,null,null,"Parcel 185"]
[null,null,null,null,null,null,null,"Parcel 186"]
[null,null,null,null,null,null,null,"Parcel 187"]
[null,null,null,null,null,null,null,"Parcel 188"]
[null,null,null,null,null,null,null,"Parcel 189"]
[null,null,null,null,null,null,null,"Parcel 190"]
[null,null,null,null,null,null,null,"Parcel 191"]
[null,null,null,null,null,null,null,"Parcel 192"]
[null,null,null,null,null,null,null,"Parcel 193"]
[null,null,null,null,null,null,null,"Parcel 194"]
[null,null,null,null,null,null,null,"Parcel 195"]
[null,null,null,null,null,null,null,"Parcel 196"]
[null,null,null,null,null,null,null,"Parcel 197"]
[null,null,null,null,null,null,null,"Parcel 198"]
[null,null,null,null,null,null,null,"Parcel 199"]
[null,null,null,null,null,null,null,"Parcel 200"]
[null,null,null,null,null,null,null,"Parcel 201"]
[null,null,null,null,null,null,null,"Parcel 202"]
[null,null,null,null,null,null,null,"Parcel 203"]
[null,null,null,null,null,null,null,"Parcel 204"]
[null,null,null,null,null,null,null,"Parcel 205"]
[null,null,null,null,null,null,null,"Parcel 206"]
[null,null,null,null,null,null,null,"Parcel 207"]
[null,null,null,null,null,null,null,"Parcel 208"]
[null,null,null,null,null,null,null,"Parcel 209"]
[null,null,null,null,null,null,null,"Parcel 210"]
[null,null,null,null,null,null,null,"Parcel 211"]
[null,null,null,null,null,null,null,"Parcel 212"]
[null,null,null,null,null,null,null,"Parcel 213"]
[null,null,null,null,null,null,null,"Parcel 214"]
[null,null,null,null,null,null,null,"Parcel 215"]
[null,null,null,null,null,null,null,"Parcel 216"]
[null,null,null,null,null,null,null,"Parcel 217"]
[null,null,null,null,null,null,null,"Parcel 218"]
[null,null,null,null,null,null,null,"Parcel 219"]
[null,null,null,null,null,null,null,"Parcel 220"]
[null,null,null,null,null,null,null,"Parcel 221"]
[null,null,null,null,null,null,null,"Parcel 222"]
[null,null,null,null,null,null,null,"Parcel 223"]
[null,null,null,null,null,null,null,"Parcel 224"]
[null,null,null,null,null,null,null,"Parcel 225"]
[null,null,null,null,null,null,null,"Parcel 226"]
[null,null,null,null,null,null,null,"Parcel 227"]
[null,null,null,null,null,null,null,"Parcel 228"]
[null,null,null,null,null,null,null,"Parcel 229"]
[null,null,null,null,null,null,null,"Parcel 230"]
[null,null,null,null,null,null,null,"Parcel 231"]
[null,null,null,null,null,null,null,"Parcel 232"]
[null,null,null,null,null,null,null,"Parcel 233"]
[null,null,null,null,null,null,null,"Parcel 234"]
[null,null,null,null,null,null,null,"Parcel 235"]
[null,null,null,null,null,null,null,"Parcel 236"]
[null,null,null,null,null,null,null,"Parcel 237"]
[null,null,null,null,null,null,null,"Parcel 238"]
[null,null,null,null,null,null,null,"Parcel 239"]
[null,null,null,null,null,null,null,"Parcel 240"]
[null,null,null,null,null,null,null,"Parcel 241"]
[null,null,null,null,null,null,null,"Parcel 242"]
[null,null,null,null,null,null,null,"Parcel 243"]
[null,null,null,null,null,null,null,"Parcel 244"]
[null,null,null,null,null,null,null,"Parcel 245"]
[null,null,null,null,null,null,null,"Parcel 246"]
[null,null,null,null,null,null,null,"Parcel 247"]
[null,null,null,null,null,null,null,"Parcel 248"]
[null,null,null,null,null,null,null,"Parcel 249"]
[null,null,null,null,null,null,null,"Parcel 250"]
[null,null,null,null,null,null,null,"Parcel 251"]
[null,null,null,null,null,null,null,"Parcel 252"]
[null,null,null,null,null,null,null,"Parcel 253"]
[null,null,null,null,null,null,null,"Parcel 254"]
[null,null,null,null,null,null,null,"Parcel 255"]
[null,null,null,null,null,null,null,"Parcel 256"]
[null,null,null,null,null,null,null,"Parcel 257"]
[null,null,null,null,null,null,null,"Parcel 258"]
[null,null,null,null,null,null,null,"Parcel 259"]
[null,null,null,null,null,null,null,"Parcel 260"]
[null,null,null,null,null,null,null,"Parcel 261"]
[null,null,null,null,null,null,null,"Parcel 262"]
[null,null,null,null,null,null,null,"Parcel 263"]
[null,null,null,null,null,null,null,"Parcel 264"]
[null,null,null,null,null,null,null,"Parcel 265"]
[null,null,null,null,null,null,null,"Parcel 266"]
[null,null,null,null,null,null,null,"Parcel 267"]
[null,null,null,null,null,null,null,"Parcel 268"]
[null,null,null,null,null,null,null,"Parcel 269"]
[null,null,null,null,null,null,null,"Parcel 270"]
[null,null,null,null,null,null,null,"Parcel 271"]
[null,null,null,null,null,null,null,"Parcel 272"]
[null,null,null,null,null,null,null,"Parcel 273"]
[null,null,null,null,null,null,null,"Parcel 274"]
[null,null,null,null,null,null,null,"Parcel 275"]
[null,null,null,null,null,null,null,"Parcel 276"]
[null,null,null,null,null,null,null,"Parcel 277"]
[null,null,null,null,null,null,null,"Parcel 278"]
[null,null,null,null,null,null,null,"Parcel 279"]
[null,null,null,null,null,null,null,"Parcel 280"]
[null,null,null,null,null,null,null,"Parcel 281"]
[null,null,null,null,null,null,null,"Parcel 282"]
[null,null,null,null,null,null,null,"Parcel 283"]
[null,null,null,null,null,null,null,"Parcel 284"]
[null,null,null,null,null,null,null,"Parcel 285"]
[null,null,null,null,null,null,null,"Parcel 286"]
[null,null,null,null,null,null,null,"Parcel 287"]
[null,null,null,null,null,null,null,"Parcel 288"]
[null,null,null,null,null,null,null,"Parcel 289"]
[null,null,null,null,null,null,null,"Parcel 290"]
[null,null,null,null,null,null,null,"Parcel 291"]
[null,null,null,null,null,null,null,"Parcel 292"]
[null,null,null,null,null,null,null,"Parcel 293"]
[null,null,null,null,null,null,null,"Parcel 294"]
[null,null,null,null,null,null,null,"Parcel 295"]
[null,null,null,null,null,null,null,"Parcel 296"]
[null,null,null,null,null,null,null,"Parcel 297"]
[null,null,null,null,null,null,null,"Parcel 298"]
[null,null,null,null,null,null,null,"Parcel 299"]
[null,null,null,null,null,null,null,"Parcel 300"]
[null,null,null,null,null,null,null,"Parcel 301"]
[null,null,null,null,null,null,null,"Parcel 302"]
[null,null,null,null,null,null,null,"Parcel 303"]
[null,null,null,null,null,null,null,"Parcel 304"]
[null,null,null,null,null,null,null,"Parcel 305"]
[null,null,null,null,null,null,null,"Parcel 306"]
[null,null,null,null,null,null,null,"Parcel 307"]
[null,null,null,null,null,null,null,"Parcel 308"]
[null,null,null,null,null,null,null,"Parcel 309"]
[null,null,null,null,null,null,null,"Parcel 310"]
[null,null,null,null,null,null,null,"Parcel 311"]
[null,null,null,null,null,null,null,"Parcel 312"]
[null,null,null,null,null,null,null,"Parcel 313"]
[null,null,null,null,null,null,null,"Parcel 314"]
[null,null,null,null,null,null,null,"Parcel 315"]
[null,null,null,null,null,null,null,"Parcel 316"]
[null,null,null,null,null,null,null,"Parcel 317"]
[null,null,null,null,null,null,null,"Parcel 318"]
[null,null,null,null,null,null,null,"Parcel 319"]
[null,null,null,null,null,null,null,"Parcel 320"]
[null,null,null,null,null,null,null,"Parcel 321"]
[null,null,null,null,null,null,null,"Parcel 322"]
[null,null,null,null,null,null,null,"Parcel 323"]
[null,null,null,null,null,null,null,"Parcel 324"]
[null,null,null,null,null,null,null,"Parcel 325"]
[null,null,null,null,null,null,null,"Parcel 326"]
[null,null,null,null,null,null,null,"Parcel 327"]
[null,null,null,null,null,null,null,"Parcel 328"]
[null,null,null,null,null,null,null,"Parcel 329"]
[null,null,null,null,null,null,null,"Parcel 330"]
[null,null,null,null,null,null,null,"Parcel 331"]
[null,null,null,null,null,null,null,"Parcel 332"]
[null,null,null,null,null,null,null,"Parcel 333"]
[null,null,null,null,null,null,null,"Parcel 334"]
[null,null,null,null,null,null,null,"Parcel 335"]
[null,null,null,null,null,null,null,"Parcel 336"]
[null,null,null,null,null,null,null,"Parcel 337"]
[null,null,null,null,null,null,null,"Parcel 338"]
[null,null,null,null,null,null,null,"Parcel 339"]
[null,null,null,null,null,null,null,"Parcel 340"]
[null,null,null,null,null,null,null,"Parcel 341"]
[null,null,null,null,null,null,null,"Parcel 342"]
[null,null,null,null,null,null,null,"Parcel 343"]
[null,null,null,null,null,null,null,"Parcel 344"]
[null,null,null,null,null,null,null,"Parcel 345"]
[null,null,null,null,null,null,null,"Parcel 346"]
[null,null,null,null,null,null,null,"Parcel 347"]
[null,null,null,null,null,null,null,"Parcel 348"]
[null,null,null,null,null,null,null,"Parcel 349"]
[null,null,null,null,null,null,null,"Parcel 350"]
[null,null,null,null,null,null,null,"Parcel 351"]
[null,null,null,null,null,null,null,"Parcel 352"]
[null,null,null,null,null,null,null,"Parcel 353"]
[null,null,null,null,null,null,null,"Parcel 354"]
[null,null,null,null,null,null,null,"Parcel 355"]
[null,null,null,null,null,null,null,"Parcel 356"]
[null,null,null,null,null,null,null,"Parcel 357"]
[null,null,null,null,null,null,null,"Parcel 358"]
[null,null,null,null,null,null,null,"Parcel 359"]
[null,null,null,null,null,null,null,"Parcel 360"]
[null,null,null,null,null,null,null,"Parcel 361"]
[null,null,null,null,null,null,null,"Parcel 362"]
[null,null,null,null,null,null,null,"Parcel 363"]
[null,null,null,null,null,null,null,"Parcel 364"]
[null,null,null,null,null,null,null,"Parcel 365"]
[null,null,null,null,null,null,null,"Parcel 366"]
[null,null,null,null,null,null,null,"Parcel 367"]
[null,null,null,null,null,null,null,"Parcel 368"]
[null,null,null,null,null,null,null,"Parcel 369"]
[null,null,null,null,null,null,null,"Parcel 370"]
[null,null,null,null,null,null,null,"Parcel 371"]
[null,null,null,null,null,null,null,"Parcel 372"]
[null,null,null,null,null,null,null,"Parcel 373"]
[null,null,null,null,null,null,null,"Parcel 374"]
[null,null,null,null,null,null,null,"Parcel 375"]
[null,null,null,null,null,null,null,"Parcel 376"]
[null,null,null,null,null,null,null,"Parcel 377"]
[null,null,null,null,null,null,null,"Parcel 378"]
[null,null,null,null,null,null,null,"Parcel 379"]
[null,null,null,null,null,null,null,"Parcel 380"]
[null,null,null,null,null,null,null,"Parcel 381"]
[null,null,null,null,null,null,null,"Parcel 382"]
[null,null,null,null,null,null,null,"Parcel 383"]
[null,null,null,null,null,null,null,"Parcel 384"]
[null,null,null,null,null,null,null,"Parcel 385"]
[null,null,null,null,null,null,null,"Parcel 386"]
[null,null,null,null,null,null,null,"Parcel 387"]
[null,null,null,null,null,null,null,"Parcel 388"]
[null,null,null,null,null,null,null,"Parcel 389"]
[null,null,null,null,null,null,null,"Parcel 390"]
[null,null,null,null,null,null,null,"Parcel 391"]
[null,null,null,null,null,null,null,"Parcel 392"]
[null,null,null,null,null,null,null,"Parcel 393"]
[null,null,null,null,null,null,null,"Parcel 394"]
[null,null,null,null,null,null,null,"Parcel 395"]
[null,null,null,null,null,null,null,"Parcel 396"]
[null,null,null,null,null,null,null,"Parcel 397"]
[null,null,null,null,null,null,null,"Parcel 398"]
[null,null,null,null,null,null,null,"Parcel 399"]
[null,null,null,null,null,null,null,"Parcel 400"]
[null,null,null,null,null,null,null,"Parcel 401"]
[null,null,null,null,null,null,null,"Parcel 402"]
[null,null,null,null,null,null,null,"Parcel 403"]
[null,null,null,null,null,null,null,"Parcel 404"]
[null,null,null,null,null,null,null,"Parcel 405"]
[null,null,null,null,null,null,null,"Parcel 406"]
[null,null,null,null,null,null,null,"Parcel 407"]
[null,null,null,null,null,null,null,"Parcel 408"]
[null,null,null,null,null,null,null,"Parcel 409"]
[null,null,null,null,null,null,null,"Parcel 410"]
[null,null,null,null,null,null,null,"Parcel 411"]
[null,null,null,null,null,null,null,"Parcel 412"]
[null,null,null,null,null,null,null,"Parcel 413"]
[null,null,null,null,null,null,null,"Parcel 414"]
[null,null,null,null,null,null,null,"Parcel 415"]
[null,null,null,null,null,null,null,"Parcel 416"]
[null,null,null,null,null,null,null,"Parcel 417"]
[null,null,null,null,null,null,null,"Parcel 418"]
[null,null,null,null,null,null,null,"Parcel 419"]
[null,null,null,null,null,null,null,"Parcel 420"]
[null,null,null,null,null,null,null,"Parcel 421"]
[null,null,null,null,null,null,null,"Parcel 422"]
[null,null,null,null,null,null,null,"Parcel 423"]
[null,null,null,null,null,null,null,"Parcel 424"]
[null,null,null,null,null,null,null,"Parcel 425"]
[null,null,null,null,null,null,null,"Parcel 426"]
[null,null,null,null,null,null,null,"Parcel 427"]
[null,null,null,null,null,null,null,"Parcel 428"]
[null,null,null,null,null,null,null,"Parcel 429"]
[null,null,null,null,null,null,null,"Parcel 430"]
[null,null,null,null,null,null,null,"Parcel 431"]
[null,null,null,null,null,null,null,"Parcel 432"]
[null,null,null,null,null,null,null,"Parcel 433"]
[null,null,null,null,null,null,null,"Parcel 434"]
[null,null,null,null,null,null,null,"Parcel 435"]
[null,null,null,null,null,null,null,"Parcel 436"]
[null,null,null,null,null,null,null,"Parcel 437"]
[null,null,null,null,null,null,null,"Parcel 438"]
[null,null,null,null,null,null,null,"Parcel 439"]
[null,null,null,null,null,null,null,"Parcel 440"]
[null,null,null,null,null,null,null,"Parcel 441"]
[null,null,null,null,null,null,null,"Parcel 442"]
[null,null,null,null,null,null,null,"Parcel 443"]
[null,null,null,null,null,null,null,"Parcel 444"]
[null,null,null,null,null,null,null,"Parcel 445"]
[null,null,null,null,null,null,null,"Parcel 446"]
[null,null,null,null,null,null,null,"Parcel 447"]
[null,null,null,null,null,null,null,"Parcel 448"]
[null,null,null,null,null,null,null,"Parcel 449"]
[null,null,null,null,null,null,null,"Parcel 450"]
[null,null,null,null,null,null,null,"Parcel 451"]
[null,null,null,null,null,null,null,"Parcel 452"]
[null,null,null,null,null,null,null,"Parcel 453"]
[null,null,null,null,null,null,null,"Parcel 454"]
[null,null,null,null,null,null,null,"Parcel 455"]
[null,null,null,null,null,null,null,"Parcel 456"]
[null,null,null,null,null,null,null,"Parcel 457"]
[null,null,null,null,null,null,null,"Parcel 458"]
[null,null,null,null,null,null,null,"Parcel 459"]
[null,null,null,null,null,null,null,"Parcel 460"]
[null,null,null,null,null,null,null,"Parcel 461"]
[null,null,null,null,null,null,null,"Parcel 462"]
[null,null,null,null,null,null,null,"Parcel 463"]
[null,null,null,null,null,null,null,"Parcel 464"]
[null,null,null,null,null,null,null,"Parcel 465"]
[null,null,null,null,null,null,null,"Parcel 466"]
[null,null,null,null,null,null,null,"Parcel 467"]
[null,null,null,null,null,null,null,"Parcel 468"]
[null,null,null,null,null,null,null,"Parcel 469"]
[null,null,null,null,null,null,null,"Parcel 470"]
[null,null,null,null,null,null,null,"Parcel 471"]
[null,null,null,null,null,null,null,"Parcel 472"]
[null,null,null,null,null,null,null,"Parcel 473"]
[null,null,null,null,null,null,null,"Parcel 474"]
[null,null,null,null,null,null,null,"Parcel 475"]
[null,null,null,null,null,null,null,"Parcel 476"]
[null,null,null,null,null,null,null,"Parcel 477"]
[null,null,null,null,null,null,null,"Parcel 478"]
[null,null,null,null,null,null,null,"Parcel 479"]
[null,null,null,null,null,null,null,"Parcel 480"]
[null,null,null,null,null,null,null,"Parcel 481"]
[null,null,null,null,null,null,null,"Parcel 482"]
[null,null,null,null,null,null,null,"Parcel 483"]
[null,null,null,null,null,null,null,"Parcel 484"]
[null,null,null,null,null,null,null,"Parcel 485"]
[null,null,null,null,null,null,null,"Parcel 486"]
[null,null,null,null,null,null,null,"Parcel 487"]
[null,null,null,null,null,null,null,"Parcel 488"]
[null,null,null,null,null,null,null,"Parcel 489"]
[null,null,null,null,null,null,null,"Parcel 490"]
[null,null,null,null,null,null,null,"Parcel 491"]
[null,null,null,null,null,null,null,"Parcel 492"]
[null,null,null,null,null,null,null,"Parcel 493"]
[null,null,null,null,null,null,null,"Parcel 494"]
[null,null,null,null,null,null,null,"Parcel 495"]
[null,null,null,null,null,null,null,"Parcel 496"]
[null,null,null,null,null,null,null,"Parcel 497"]
[null,null,null,null,null,null,null,"Parcel 498"]
[null,null,null,null,null,null,null,"Parcel 499"]
[null,null,null,null,null,null,null,"Parcel 500"]
[null,null,null,null,null,null,null,"Parcel 501"]
[null,null,null,null,null,null,null,"Parcel 502"]
[null,null,null,null,null,null,null,"Parcel 503"]
[null,null,null,null,null,null,null,"Parcel 504"]
[null,null,null,null,null,null,null,"Parcel 505"]
[null,null,null,null,null,null,null,"Parcel 506"]
[null,null,null,null,null,null,null,"Parcel 507"]
[null,null,null,null,null,null,null,"Parcel 508"]
[null,null,null,null,null,null,null,"Parcel 509"]
[null,null,null,null,null,null,null,"Parcel 510"]
[null,null,null,null,null,null,null,"Parcel 511"]
[null,null,null,null,null,null,null,"Parcel 512"]
[null,null,null,null,null,null,null,"Parcel 513"]
[null,null,null,null,null,null,null,"Parcel 514"]
[null,null,null,null,null,null,null,"Parcel 515"]
[null,null,null,null,null,null,null,"Parcel 516"]
[null,null,null,null,null,null,null,"Parcel 517"]
[null,null,null,null,null,null,null,"Parcel 518"]
[null,null,null,null,null,null,null,"Parcel 519"]
[null,null,null,null,null,null,null,"Parcel 520"]
[null,null,null,null,null,null,null,"Parcel 521"]
[null,null,null,null,null,null,null,"Parcel 522"]
[null,null,null,null,null,null,null,"Parcel 523"]
[null,null,null,null,null,null,null,"Parcel 524"]
[null,null,null,null,null,null,null,"Parcel 525"]
[null,null,null,null,null,null,null,"Parcel 526"]
[null,null,null,null,null,null,null,"Parcel 527"]
[null,null,null,null,null,null,null,"Parcel 528"]
[null,null,null,null,null,null,null,"Parcel 529"]
[null,null,null,null,null,null,null,"Parcel 530"]
[null,null,null,null,null,null,null,"Parcel 531"]
[null,null,null,null,null,null,null,"Parcel 532"]
[null,null,null,null,null,null,null,"Parcel 533"]
[null,null,null,null,null,null,null,"Parcel 534"]
[null,null,null,null,null,null,null,"Parcel 535"]
[null,null,null,null,null,null,null,"Parcel 536"]
[null,null,null,null,null,null,null,"Parcel 537"]
[null,null,null,null,null,null,null,"Parcel 538"]
[null,null,null,null,null,null,null,"Parcel 539"]
[null,null,null,null,null,null,null,"Parcel 540"]
[null,null,null,null,null,null,null,"Parcel 541"]
[null,null,null,null,null,null,null,"Parcel 542"]
[null,null,null,null,null,null,null,"Parcel 543"]
[null,null,null,null,null,null,null,"Parcel 544"]
[null,null,null,null,null,null,null,"Parcel 545"]
[null,null,null,null,null,null,null,"Parcel 546"]
[null,null,null,null,null,null,null,"Parcel 547"]
[null,null,null,null,null,null,null,"Parcel 548"]
[null,null,null,null,null,null,null,"Parcel 549"]
[null,null,null,null,null,null,null,"Parcel 550"]
[null,null,null,null,null,null,null,"Parcel 551"]
[null,null,null,null,null,null,null,"Parcel 552"]
[null,null,null,null,null,null,null,"Parcel 553"]
[null,null,null,null,null,null,null,"Parcel 554"]
[null,null,null,null,null,null,null,"Parcel 555"]
[null,null,null,null,null,null,null,"Parcel 556"]
[null,null,null,null,null,null,null,"Parcel 557"]
[null,null,null,null,null,null,null,"Parcel 558"]
[null,null,null,null,null,null,null,"Parcel 559"]
[null,null,null,null,null,null,null,"Parcel 560"]
[null,null,null,null,null,null,null,"Parcel 561"]
[null,null,null,null,null,null,null,"Parcel 562"]
[null,null,null,null,null,null,null,"Parcel 563"]
[null,null,null,null,null,null,null,"Parcel 564"]
[null,null,null,null,null,null,null,"Parcel 565"]
[null,null,null,null,null,null,null,"Parcel 566"]
[null,null,null,null,null,null,null,"Parcel 567"]
[null,null,null,null,null,null,null,"Parcel 568"]
[null,null,null,null,null,null,null,"Parcel 569"]
[null,null,null,null,null,null,null,"Parcel 570"]
[null,null,null,null,null,null,null,"Parcel 571"]
[null,null,null,null,null,null,null,"Parcel 572"]
[null,null,null,null,null,null,null,"Parcel 573"]
[null,null,null,null,null,null,null,"Parcel 574"]
[null,null,null,null,null,null,null,"Parcel 575"]
[null,null,null,null,null,null,null,"Parcel 576"]
[null,null,null,null,null,null,null,"Parcel 577"]
[null,null,null,null,null,null,null,"Parcel 578"]
[null,null,null,null,null,null,null,"Parcel 579"]
[null,null,null,null,null,null,null,"Parcel 580"]
[null,null,null,null,null,null,null,"Parcel 581"]
[null,null,null,null,null,null,null,"Parcel 582"]
[null,null,null,null,null,null,null,"Parcel 583"]
[null,null,null,null,null,null,null,"Parcel 584"]
[null,null,null,null,null,null,null,"Parcel 585"]
[null,null,null,null,null,null,null,"Parcel 586"]
[null,null,null,null,null,null,null,"Parcel 587"]
[null,null,null,null,null,null,null,"Parcel 588"]
[null,null,null,null,null,null,null,"Parcel 589"]
[null,null,null,null,null,null,null,"Parcel 590"]
[null,null,null,null,null,null,null,"Parcel 591"]
[null,null,null,null,null,null,null,"Parcel 592"]
[null,null,null,null,null,null,null,"Parcel 593"]
[null,null,null,null,null,null,null,"Parcel 594"]
[null,null,null,null,null,null,null,"Parcel 595"]
[null,null,null,null,null,null,null,"Parcel 596"]
[null,null,null,null,null,null,null,"Parcel 597"]
[null,null,null,null,null,null,null,"Parcel 598"]
[null,null,null,null,null,null,null,"Parcel 599"]
[null,null,null,null,null,null,null,"Parcel 600"]
[null,null,null,null,null,null,null,"Parcel 601"]
[null,null,null,null,null,null,null,"Parcel 602"]
[null,null,null,null,null,null,null,"Parcel 603"]
[null,null,null,null,null,null,null,"Parcel 604"]
[null,null,null,null,null,null,null,"Parcel 605"]
[null,null,null,null,null,null,null,"Parcel 606"]
[null,null,null,null,null,null,null,"Parcel 607"]
[null,null,null,null,null,null,null,"Parcel 608"]
[null,null,null,null,null,null,null,"Parcel 609"]
[null,null,null,null,null,null,null,"Parcel 610"]
[null,null,null,null,null,null,null,"Parcel 611"]
[null,null,null,null,null,null,null,"Parcel 612"]
[null,null,null,null,null,null,null,"Parcel 613"]
[null,null,null,null,null,null,null,"Parcel 614"]
[null,null,null,null,null,null,null,"Parcel 615"]
[null,null,null,null,null,null,null,"Parcel 616"]
[null,null,null,null,null,null,null,"Parcel 617"]
[null,null,null,null,null,null,null,"Parcel 618"]
[null,null,null,null,null,null,null,"Parcel 619"]
[null,null,null,null,null,null,null,"Parcel 620"]
[null,null,null,null,null,null,null,"Parcel 621"]
[null,null,null,null,null,null,null,"Parcel 622"]
[null,null,null,null,null,null,null,"Parcel 623"]
[null,null,null,null,null,null,null,"Parcel 624"]
[null,null,null,null,null,null,null,"Parcel 625"]
[null,null,null,null,null,null,null,"Parcel 626"]
[null,null,null,null,null,null,null,"Parcel 627"]
[null,null,null,null,null,null,null,"Parcel 628"]
[null,null,null,null,null,null,null,"Parcel 629"]
[null,null,null,null,null,null,null,"Parcel 630"]
[null,null,null,null,null,null,null,"Parcel 631"]
[null,null,null,null,null,null,null,"Parcel 632"]
[null,null,null,null,null,null,null,"Parcel 633"]
[null,null,null,null,null,null,null,"Parcel 634"]
[null,null,null,null,null,null,null,"Parcel 635"]
[null,null,null,null,null,null,null,"Parcel 636"]
[null,null,null,null,null,null,null,"Parcel 637"]
[null,null,null,null,null,null,null,"Parcel 638"]
[null,null,null,null,null,null,null,"Parcel 639"]
[null,null,null,null,null,null,null,"Parcel 640"]
[null,null,null,null,null,null,null,"Parcel 641"]
[null,null,null,null,null,null,null,"Parcel 642"]
[null,null,null,null,null,null,null,"Parcel 643"]
[null,null,null,null,null,null,null,"Parcel 644"]
[null,null,null,null,null,null,null,"Parcel 645"]
[null,null,null,null,null,null,null,"Parcel 646"]
[null,null,null,null,null,null,null,"Parcel 647"]
[null,null,null,null,null,null,null,"Parcel 648"]
[null,null,null,null,null,null,null,"Parcel 649"]
[null,null,null,null,null,null,null,"Parcel 650"]
[null,null,null,null,null,null,null,"Parcel 651"]
[null,null,null,null,null,null,null,"Parcel 652"]
[null,null,null,null,null,null,null,"Parcel 653"]
[null,null,null,null,null,null,null,"Parcel 654"]
[null,null,null,null,null,null,null,"Parcel 655"]
[null,null,null,null,null,null,null,"Parcel 656"]
[null,null,null,null,null,null,null,"Parcel 657"]
[null,null,null,null,null,null,null,"Parcel 658"]
[null,null,null,null,null,null,null,"Parcel 659"]
[null,null,null,null,null,null,null,"Parcel 660"]
[null,null,null,null,null,null,null,"Parcel 661"]
[null,null,null,null,null,null,null,"Parcel 662"]
[null,null,null,null,null,null,null,"Parcel 663"]
[null,null,null,null,null,null,null,"Parcel 664"]
[null,null,null,null,null,null,null,"Parcel 665"]
[null,null,null,null,null,null,null,"Parcel 666"]
[null,null,null,null,null,null,null,"Parcel 667"]
[null,null,null,null,null,null,null,"Parcel 668"]
[null,null,null,null,null,null,null,"Parcel 669"]
[null,null,null,null,null,null,null,"Parcel 670"]
[null,null,null,null,null,null,null,"Parcel 671"]
[null,null,null,null,null,null,null,"Parcel 672"]
[null,null,null,null,null,null,null,"Parcel 673"]
[null,null,null,null,null,null,null,"Parcel 674"]
[null,null,null,null,null,null,null,"Parcel 675"]
[null,null,null,null,null,null,null,"Parcel 676"]
[null,null,null,null,null,null,null,"Parcel 677"]
[null,null,null,null,null,null,null,"Parcel 678"]
[null,null,null,null,null,null,null,"Parcel 679"]
[null,null,null,null,null,null,null,"Parcel 680"]
[null,null,null,null,null,null,null,"Parcel 681"]
[null,null,null,null,null,null,null,"Parcel 682"]
[null,null,null,null,null,null,null,"Parcel 683"]
[null,null,null,null,null,null,null,"Parcel 684"]
[null,null,null,null,null,null,null,"Parcel 685"]
[null,null,null,null,null,null,null,"Parcel 686"]
[null,null,null,null,null,null,null,"Parcel 687"]
[null,null,null,null,null,null,null,"Parcel 688"]
[null,null,null,null,null,null,null,"Parcel 689"]
[null,null,null,null,null,null,null,"Parcel 690"]
[null,null,null,null,null,null,null,"Parcel 691"]
[null,null,null,null,null,null,null,"Parcel 692"]
[null,null,null,null,null,null,null,"Parcel 693"]
[null,null,null,null,null,null,null,"Parcel 694"]
[null,null,null,null,null,null,null,"Parcel 695"]
[null,null,null,null,null,null,null,"Parcel 696"]
[null,null,null,null,null,null,null,"Parcel 697"]
[null,null,null,null,null,null,null,"Parcel 698"]
[null,null,null,null,null,null,null,"Parcel 699"]
[null,null,null,null,null,null,null,"Parcel 700"]
[null,null,null,null,null,null,null,"Parcel 701"]
[null,null,null,null,null,null,null,"Parcel 702"]
[null,null,null,null,null,null,null,"Parcel 703"]
[null,null,null,null,null,null,null,"Parcel 704"]
[null,null,null,null,null,null,null,"Parcel 705"]
[null,null,null,null,null,null,null,"Parcel 706"]
[null,null,null,null,null,null,null,"Parcel 707"]
[null,null,null,null,null,null,null,"Parcel 708"]
[null,null,null,null,null,null,null,"Parcel 709"]
[null,null,null,null,null,null,null,"Parcel 710"]
[null,null,null,null,null,null,null,"Parcel 711"]
[null,null,null,null,null,null,null,"Parcel 712"]
[null,null,null,null,null,null,null,"Parcel 713"]
[null,null,null,null,null,null,null,"Parcel 714"]
[null,null,null,null,null,null,null,"Parcel 715"]
[null,null,null,null,null,null,null,"Parcel 716"]
[null,null,null,null,null,null,null,"Parcel 717"]
[null,null,null,null,null,null,null,"Parcel 718"]
[null,null,null,null,null,null,null,"Parcel 719"]
[null,null,null,null,null,null,null,"Parcel 720"]
[null,null,null,null,null,null,null,"Parcel 721"]
[null,null,null,null,null,null,null,"Parcel 722"]
[null,null,null,null,null,null,null,"Parcel 723"]
[null,null,null,null,null,null,null,"Parcel 724"]
[null,null,null,null,null,null,null,"Parcel 725"]
[null,null,null,null,null,null,null,"Parcel 726"]
[null,null,null,null,null,null,null,"Parcel 727"]
[null,null,null,null,null,null,null,"Parcel 728"]
[null,null,null,null,null,null,null,"Parcel 729"]
[null,null,null,null,null,null,null,"Parcel 730"]
[null,null,null,null,null,null,null,"Parcel 731"]
[null,null,null,null,null,null,null,"Parcel 732"]
[null,null,null,null,null,null,null,"Parcel 733"]
[null,null,null,null,null,null,null,"Parcel 734"]
[null,null,null,null,null,null,null,"Parcel 735"]
[null,null,null,null,null,null,null,"Parcel 736"]
[null,null,null,null,null,null,null,"Parcel 737"]
[null,null,null,null,null,null,null,"Parcel 738"]
[null,null,null,null,null,null,null,"Parcel 739"]
[null,null,null,null,null,null,null,"Parcel 740"]
[null,null,null,null,null,null,null,"Parcel 741"]
[null,null,null,null,null,null,null,"Parcel 742"]
[null,null,null,null,null,null,null,"Parcel 743"]
[null,null,null,null,null,null,null,"Parcel 744"]
[null,null,null,null,null,null,null,"Parcel 745"]
[null,null,null,null,null,null,null,"Parcel 746"]
[null,null,null,null,null,null,null,"Parcel 747"]
[null,null,null,null,null,null,null,"Parcel 748"]
[null,null,null,null,null,null,null,"Parcel 749"]
[null,null,null,null,null,null,null,"Parcel 750"]
[null,null,null,null,null,null,null,"Parcel 751"]
[null,null,null,null,null,null,null,"Parcel 752"]
[null,null,null,null,null,null,null,"Parcel 753"]
[null,null,null,null,null,null,null,"Parcel 754"]
[null,null,null,null,null,null,null,"Parcel 755"]
[null,null,null,null,null,null,null,"Parcel 756"]
[null,null,null,null,null,null,null,"Parcel 757"]
[null,null,null,null,null,null,null,"Parcel 758"]
[null,null,null,null,null,null,null,"Parcel 759"]
[null,null,null,null,null,null,null,"Parcel 760"]
[null,null,null,null,null,null,null,"Parcel 761"]
[null,null,null,null,null,null,null,"Parcel 762"]
[null,null,null,null,null,null,null,"Parcel 763"]
[null,null,null,null,null,null,null,"Parcel 764"]
[null,null,null,null,null,null,null,"Parcel 765"]
[null,null,null,null,null,null,null,"Parcel 766"]
[null,null,null,null,null,null,null,"Parcel 767"]
[null,null,null,null,null,null,null,"Parcel 768"]
[null,null,null,null,null,null,null,"Parcel 769"]
[null,null,null,null,null,null,null,"Parcel 770"]
[null,null,null,null,null,null,null,"Parcel 771"]
[null,null,null,null,null,null,null,"Parcel 772"]
[null,null,null,null,null,null,null,"Parcel 773"]
[null,null,null,null,null,null,null,"Parcel 774"]
[null,null,null,null,null,null,null,"Parcel 775"]
[null,null,null,null,null,null,null,"Parcel 776"]
[null,null,null,null,null,null,null,"Parcel 777"]
[null,null,null,null,null,null,null,"Parcel 778"]
[null,null,null,null,null,null,null,"Parcel 779"]
[null,null,null,null,null,null,null,"Parcel 780"]
[null,null,null,null,null,null,null,"Parcel 781"]
[null,null,null,null,null,null,null,"Parcel 782"]
[null,null,null,null,null,null,null,"Parcel 783"]
[null,null,null,null,null,null,null,"Parcel 784"]
[null,null,null,null,null,null,null,"Parcel 785"]
[null,null,null,null,null,null,null,"Parcel 786"]
[null,null,null,null,null,null,null,"Parcel 787"]
[null,null,null,null,null,null,null,"Parcel 788"]
[null,null,null,null,null,null,null,"Parcel 789"]
[null,null,null,null,null,null,null,"Parcel 790"]
[null,null,null,null,null,null,null,"Parcel 791"]
[null,null,null,null,null,null,null,"Parcel 792"]
[null,null,null,null,null,null,null,"Parcel 793"]
[null,null,null,null,null,null,null,"Parcel 794"]
[null,null,null,null,null,null,null,"Parcel 795"]
[null,null,null,null,null,null,null,"Parcel 796"]
[null,null,null,null,null,null,null,"Parcel 797"]
[null,null,null,null,null,null,null,"Parcel 798"]
[null,null,null,null,null,null,null,"Parcel 799"]
[null,null,null,null,null,null,null,"Parcel 800"]
[null,null,null,null,null,null,null,"Parcel 801"]
[null,null,null,null,null,null,null,"Parcel 802"]
[null,null,null,null,null,null,null,"Parcel 803"]
[null,null,null,null,null,null,null,"Parcel 804"]
[null,null,null,null,null,null,null,"Parcel 805"]
[null,null,null,null,null,null,null,"Parcel 806"]
[null,null,null,null,null,null,null,"Parcel 807"]
[null,null,null,null,null,null,null,"Parcel 808"]
[null,null,null,null,null,null,null,"Parcel 809"]
[null,null,null,null,null,null,null,"Parcel 810"]
[null,null,null,null,null,null,null,"Parcel 811"]
[null,null,null,null,null,null,null,"Parcel 812"]
[null,null,null,null,null,null,null,"Parcel 813"]
[null,null,null,null,null,null,null,"Parcel 814"]
[null,null,null,null,null,null,null,"Parcel 815"]
[null,null,null,null,null,null,null,"Parcel 816"]
[null,null,null,null,null,null,null,"Parcel 817"]
[null,null,null,null,null,null,null,"Parcel 818"]
[null,null,null,null,null,null,null,"Parcel 819"]
[null,null,null,null,null,null,null,"Parcel 820"]
[null,null,null,null,null,null,null,"Parcel 821"]
[null,null,null,null,null,null,null,"Parcel 822"]
[null,null,null,null,null,null,null,"Parcel 823"]
[null,null,null,null,null,null,null,"Parcel 824"]
[null,null,null,null,null,null,null,"Parcel 825"]
[null,null,null,null,null,null,null,"Parcel 826"]
[null,null,null,null,null,null,null,"Parcel 827"]
[null,null,null,null,null,null,null,"Parcel 828"]
[null,null,null,null,null,null,null,"Parcel 829"]
[null,null,null,null,null,null,null,"Parcel 830"]
[null,null,null,null,null,null,null,"Parcel 831"]
[null,null,null,null,null,null,null,"Parcel 832"]
[null,null,null,null,null,null,null,"Parcel 833"]
[null,null,null,null,null,null,null,"Parcel 834"]
[null,null,null,null,null,null,null,"Parcel 835"]
[null,null,null,null,null,null,null,"Parcel 836"]
[null,null,null,null,null,null,null,"Parcel 837"]
[null,null,null,null,null,null,null,"Parcel 838"]
[null,null,null,null,null,null,null,"Parcel 839"]
[null,null,null,null,null,null,null,"Parcel 840"]
[null,null,null,null,null,null,null,"Parcel 841"]
[null,null,null,null,null,null,null,"Parcel 842"]
[null,null,null,null,null,null,null,"Parcel 843"]
[null,null,null,null,null,null,null,"Parcel 844"]
[null,null,null,null,null,null,null,"Parcel 845"]
[null,null,null,null,null,null,null,"Parcel 846"]
[null,null,null,null,null,null,null,"Parcel 847"]
[null,null,null,null,null,null,null,"Parcel 848"]
[null,null,null,null,null,null,null,"Parcel 849"]
[null,null,null,null,null,null,null,"Parcel 850"]
[null,null,null,null,null,null,null,"Parcel 851"]
[null,null,null,null,null,null,null,"Parcel 852"]
[null,null,null,null,null,null,null,"Parcel 853"]
[null,null,null,null,null,null,null,"Parcel 854"]
[null,null,null,null,null,null,null,"Parcel 855"]
[null,null,null,null,null,null,null,"Parcel 856"]
[null,null,null,null,null,null,null,"Parcel 857"]
[null,null,null,null,null,null,null,"Parcel 858"]
[null,null,null,null,null,null,null,"Parcel 859"]
[null,null,null,null,null,null,null,"Parcel 860"]
[null,null,null,null,null,null,null,"Parcel 861"]
[null,null,null,null,null,null,null,"Parcel 862"]
[null,null,null,null,null,null,null,"Parcel 863"]
[null,null,null,null,null,null,null,"Parcel 864"]
[null,null,null,null,null,null,null,"Parcel 865"]
[null,null,null,null,null,null,null,"Parcel 866"]
[null,null,null,null,null,null,null,"Parcel 867"]
[null,null,null,null,null,null,null,"Parcel 868"]
[null,null,null,null,null,null,null,"Parcel 869"]
[null,null,null,null,null,null,null,"Parcel 870"]
[null,null,null,null,null,null,null,"Parcel 871"]
[null,null,null,null,null,null,null,"Parcel 872"]
[null,null,null,null,null,null,null,"Parcel 873"]
[null,null,null,null,null,null,null,"Parcel 874"]
[null,null,null,null,null,null,null,"Parcel 875"]
[null,null,null,null,null,null,null,"Parcel 876"]
[null,null,null,null,null,null,null,"Parcel 877"]
[null,null,null,null,null,null,null,"Parcel 878"]
[null,null,null,null,null,null,null,"Parcel 879"]
[null,null,null,null,null,null,null,"Parcel 880"]
[null,null,null,null,null,null,null,"Parcel 881"]
[null,null,null,null,null,null,null,"Parcel 882"]
[null,null,null,null,null,null,null,"Parcel 883"]
[null,null,null,null,null,null,null,"Parcel 884"]
[null,null,null,null,null,null,null,"Parcel 885"]
[null,null,null,null,null,null,null,"Parcel 886"]
[null,null,null,null,null,null,null,"Parcel 887"]
[null,null,null,null,null,null,null,"Parcel 888"]
[null,null,null,null,null,null,null,"Parcel 889"]
[null,null,null,null,null,null,null,"Parcel 890"]
[null,null,null,null,null,null,null,"Parcel 891"]
[null,null,null,null,null,null,null,"Parcel 892"]
[null,null,null,null,null,null,null,"Parcel 893"]
[null,null,null,null,null,null,null,"Parcel 894"]
[null,null,null,null,null,null,null,"Parcel 895"]
[null,null,null,null,null,null,null,"Parcel 896"]
[null,null,null,null,null,null,null,"Parcel 897"]
[null,null,null,null,null,null,null,"Parcel 898"]
[null,null,null,null,null,null,null,"Parcel 899"]
[null,null,null,null,null,null,null,"Parcel 900"]
[null,null,null,null,null,null,null,"Parcel 901"]
[null,null,null,null,null,null,null,"Parcel 902"]
[null,null,null,null,null,null,null,"Parcel 903"]
[null,null,null,null,null,null,null,"Parcel 904"]
[null,null,null,null,null,null,null,"Parcel 905"]
[null,null,null,null,null,null,null,"Parcel 906"]
[null,null,null,null,null,null,null,"Parcel 907"]
[null,null,null,null,null,null,null,"Parcel 908"]
[null,null,null,null,null,null,null,"Parcel 909"]
[null,null,null,null,null,null,null,"Parcel 910"]
[null,null,null,null,null,null,null,"Parcel 911"]
[null,null,null,null,null,null,null,"Parcel 912"]
[null,null,null,null,null,null,null,"Parcel 913"]
[null,null,null,null,null,null,null,"Parcel 914"]
[null,null,null,null,null,null,null,"Parcel 915"]
[null,null,null,null,null,null,null,"Parcel 916"]
[null,null,null,null,null,null,null,"Parcel 917"]
[null,null,null,null,null,null,null,"Parcel 918"]
[null,null,null,null,null,null,null,"Parcel 919"]
[null,null,null,null,null,null,null,"Parcel 920"]
[null,null,null,null,null,null,null,"Parcel 921"]
[null,null,null,null,null,null,null,"Parcel 922"]
[null,null,null,null,null,null,null,"Parcel 923"]
[null,null,null,null,null,null,null,"Parcel 924"]
[null,null,null,null,null,null,null,"Parcel 925"]
[null,null,null,null,null,null,null,"Parcel 926"]
[null,null,null,null,null,null,null,"Parcel 927"]
[null,null,null,null,null,null,null,"Parcel 928"]
[null,null,null,null,null,null,null,"Parcel 929"]
[null,null,null,null,null,null,null,"Parcel 930"]
[null,null,null,null,null,null,null,"Parcel 931"]
[null,null,null,null,null,null,null,"Parcel 932"]
[null,null,null,null,null,null,null,"Parcel 933"]
[null,null,null,null,null,null,null,"Parcel 934"]
[null,null,null,null,null,null,null,"Parcel 935"]
[null,null,null,null,null,null,null,"Parcel 936"]
[null,null,null,null,null,null,null,"Parcel 937"]
[null,null,null,null,null,null,null,"Parcel 938"]
[null,null,null,null,null,null,null,"Parcel 939"]
[null,null,null,null,null,null,null,"Parcel 940"]
[null,null,null,null,null,null,null,"Parcel 941"]
[null,null,null,null,null,null,null,"Parcel 942"]
[null,null,null,null,null,null,null,"Parcel 943"]
[null,null,null,null,null,null,null,"Parcel 944"]
[null,null,null,null,null,null,null,"Parcel 945"]
[null,null,null,null,null,null,null,"Parcel 946"]
[null,null,null,null,null,null,null,"Parcel 947"]
[null,null,null,null,null,null,null,"Parcel 948"]
[null,null,null,null,null,null,null,"Parcel 949"]
[null,null,null,null,null,null,null,"Parcel 950"]
[null,null,null,null,null,null,null,"Parcel 951"]
[null,null,null,null,null,null,null,"Parcel 952"]
[null,null,null,null,null,null,null,"Parcel 953"]
[null,null,null,null,null,null,null,"Parcel 954"]
[null,null,null,null,null,null,null,"Parcel 955"]
[null,null,null,null,null,null,null,"Parcel 956"]
[null,null,null,null,null,null,null,"Parcel 957"]
[null,null,null,null,null,null,null,"Parcel 958"]
[null,null,null,null,null,null,null,"Parcel 959"]
[null,null,null,null,null,null,null,"Parcel 960"]
[null,null,null,null,null,null,null,"Parcel 961"]
[null,null,null,null,null,null,null,"Parcel 962"]
[null,null,null,null,null,null,null,"Parcel 963"]
[null,null,null,null,null,null,null,"Parcel 964"]
[null,null,null,null,null,null,null,"Parcel 965"]
[null,null,null,null,null,null,null,"Parcel 966"]
[null,null,null,null,null,null,null,"Parcel 967"]
[null,null,null,null,null,null,null,"Parcel 968"]
[null,null,null,null,null,null,null,"Parcel 969"]
[null,null,null,null,null,null,null,"Parcel 970"]
[null,null,null,null,null,null,null,"Parcel 971"]
[null,null,null,null,null,null,null,"Parcel 972"]
[null,null,null,null,null,null,null,"Parcel 973"]
[null,null,null,null,null,null,null,"Parcel 974"]
[null,null,null,null,null,null,null,"Parcel 975"]
[null,null,null,null,null,null,null,"Parcel 976"]
[null,null,null,null,null,null,null,"Parcel 977"]
[null,null,null,null,null,null,null,"Parcel 978"]
[null,null,null,null,null,null,null,"Parcel 979"]
[null,null,null,null,null,null,null,"Parcel 980"]
[null,null,null,null,null,null,null,"Parcel 981"]
[null,null,null,null,null,null,null,"Parcel 982"]
[null,null,null,null,null,null,null,"Parcel 983"]
[null,null,null,null,null,null,null,"Parcel 984"]
[null,null,null,null,null,null,null,"Parcel 985"]
[null,null,null,null,null,null,null,"Parcel 986"]
[null,null,null,null,null,null,null,"Parcel 987"]
[null,null,null,null,null,null,null,"Parcel 988"]
[null,null,null,null,null,null,null,"Parcel 989"]
[null,null,null,null,null,null,null,"Parcel 990"]
[null,null,null,null,null,null,null,"Parcel 991"]
[null,null,null,null,null,null,null,"Parcel 992"]
[null,null,null,null,null,null,null,"Parcel 993"]
[null,null,null,null,null,null,null,"Parcel 994"]
[null,null,null,null,null,null,null,"Parcel 995"]
[null,null,null,null,null,null,null,"Parcel 996"]
[null,null,null,null,null,null,null,"Parcel 997"]
[null,null,null,null,null,null,null,"Parcel 998"]
[null,null,null,null,null,null,null,"Parcel 999"]
[null,null,null,null,null,null,null,"Parcel 1000"]

{"sheet":"Relo Schedule Phase 1","index":2,"n_rows":92,"n_cols":101,"rows_kept":92,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6],[4,7,4,8],[0,3,0,4],[0,5,0,6],[1,11,1,17],[2,11,3,17],[3,2,3,3],[11,15,11,87],[5,0,5,2],[5,4,5,6],[5,11,5,17],[6,0,6,1],[6,11,7,17],[9,0,9,6],[9,7,9,14],[10,1,11,6],[10,7,11,9],[10,10,11,10],[10,11,11,13],[10,14,11,14],[32,39,32,40],[32,15,32,16],[32,17,32,18],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,28],[32,29,32,30],[32,31,32,32],[32,33,32,34],[32,35,32,36],[32,37,32,38],[32,63,32,66],[32,67,32,68],[32,41,32,42],[32,43,32,44],[32,45,32,48],[32,49,32,50],[32,51,32,52],[32,53,32,54],[32,83,32,84],[32,85,32,86],[44,25,44,29],[44,45,44,49],[44,63,44,67],[44,79,44,83],[32,69,32,70],[32,71,32,72],[32,73,32,74],[32,75,32,76],[32,77,32,78],[32,79,32,82],[32,55,32,56],[32,57,32,58],[32,59,32,60],[32,61,32,62],[80,64,80,65],[80,80,80,81],[59,4,59,5],[59,11,59,12],[80,9,80,10],[80,13,80,14],[80,27,80,28],[80,47,80,48]]}
[null,"Enter in the highlighted fields",null,"NCDOT Reviewer:",null,null,null,null,null,"V2.0"]
["Let Date:",null,"TIP #:",null,"County:",null,"Division:",{"$f":"IF(F2=\"\",\"\",VLOOKUP(F2,Guidance!B85:C183,2,FALSE))","v":""},null,null,null,"Project Description:"]
[]
["PS&E Date:",null,"Utility Priority Parcels Aquired Date:"]
["Date final PUE due from PEF to DOT:",null,"Date final PUE sent to DOT:",null,null,"PUE received date compared to PUE due date:",null,{"$f":"IF(B5=\"\",\"\",\nIF(E5=B5,\"On time\",\nIF(E5>B5,\n   IF(DATEDIF(B5,E5,\"d\")<=30, DATEDIF(B5,E5,\"d\") & \" days behind schedule\", DATEDIF(B5,E5,\"m\") & \" months behind schedule\"),\n   IF(DATEDIF(E5,B5,\"d\")<=30, DATEDIF(E5,B5,\"d\") & \" days ahead of schedule\", DATEDIF(E5,B5,\"m\") & \" months ahead of schedule\")\n)))","v":""},null,{"$f":"DATEDIF(MIN(B5,E5), MAX(B5,E5), \"m\") * SIGN(E5 - B5)","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden cell do not edit",null,null,null,null,null,null,null,null,null,"Hidden"]
["SAP Utility Relocation By Others Begins Date:",null,null,null,"SAP Utility Relocation By Others Complete Date:",null,null,null,null,null,null,"Comments related to PUE and URA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(CK13), MONTH(CK13), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,"URA","Approved"]
["Moratorium Date Range",null,"Start Date:",null,"Finish Date:",null,null,null,null,null,null,"(Provide information related to PUE and URA status)"]
[]
[]
["Agreements",null,null,null,null,null,null,"Relocation"]
[null,"Utility Coordinator shall verfiy all Utilty Owners are listed and included on the Relocation Schedule (even if not in conflict) \n",null,null,null,null,null,"First Utility Relocation Start Date: ",null,null,{"$f":"IF(\n    COUNT(_xlfn._xlws.FILTER(\n        IF(L15:L89<>\"\", L15:L89, K15:K89),\n        (NOT(ISNUMBER(SEARCH(\"verification\", A15:A89)))) *\n        (((L15:L89<>\"\") + (K15:K89<>\"\")))\n    )) = 0,\n    \"Enter a relocation start date below\",\n    MIN(_xlfn._xlws.FILTER(\n        IF(L15:L89<>\"\", L15:L89, K15:K89),\n        (NOT(ISNUMBER(SEARCH(\"verification\", A15:A89)))) *\n        (((L15:L89<>\"\") + (K15:K89<>\"\")))\n    ))\n)","v":"Enter a relocation start date below"},"Final Utility Relocation Complete Date:",null,null,{"$f":"IF(COUNT(N15:N94)+COUNT(M15:M94)=0,\"Enter a relocation start date below\",MAX(IF(N15:N94<>\"\",N15:N94,M15:M94)))","v":"Enter a relocation start date below"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT($K$16:$K$89)=0,\n    \"Enter a Relocation start date\",\nIF(H6=\"\",\n    \"Enter SAP URBOC date in cell O12\",\nIF(AND(ISNUMBER(H6), ISNUMBER(O11)),\n    IF(O11 = H6,\n        \"The Relocations are scheduled to finish at the SAP URBOC\",\n        IF(O11 < H6,\n            \"The Relocation is projected to finish before the SAP URBOC\",\n            \"The Relocation is projected to be unfinished by the SAP URBOC\"\n        )\n    ),\n\"\"\n)))","v":"Enter a Relocation start date"}]
["Utility Owner","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",{"$f":"CM6","v":"1900-01-01"},{"$f":"EDATE(P13,1)","v":"1900-02-01"},{"$f":"EDATE(Q13,1)","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","1901-01-01","1901-02-01","1901-03-01","1901-04-01","1901-05-01","1901-06-01","1901-07-01","1901-08-01","1901-09-01","1901-10-01","1901-11-01","1901-12-01","1902-01-01",{"$f":"EDATE(AN13,1)","v":"1902-02-01"},{"$f":"EDATE(AO13,1)","v":"1902-03-01"},"1902-04-01","1902-05-01","1902-06-01","1902-07-01","1902-08-01","1902-09-01","1902-10-01","1902-11-01","1902-12-01","1903-01-01","1903-02-01","1903-03-01","1903-04-01","1903-05-01","1903-06-01","1903-07-01","1903-08-01","1903-09-01","1903-10-01","1903-11-01","1903-12-01","1904-01-01","1904-02-01","1904-03-01","1904-04-01","1904-05-01","1904-06-01","1904-07-01","1904-08-01","1904-09-01","1904-10-01","1904-11-01","1904-12-01","1905-01-01","1905-02-01","1905-03-01","1905-04-01","1905-05-01","1905-06-01","1905-07-01","1905-08-01","1905-09-01","1905-10-01","1905-11-01","1905-12-01","1906-01-01",{"$f":"MIN(K11,D6,K15)","v":"00:00:00"},null,null,null,null,null,null,null,null,"U&O","Not Started"]
["UBO- Aerial/ List in order of relocation (Joint use poles)","If there is a utility that is aerial and underground you should enter utilities in both categories.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(P$13),\nDATE(YEAR(P$13),MONTH(P$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(P$13),MONTH(P$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($B$4),\nYEAR(P$13)=YEAR($B$4), MONTH(P$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($B$2),\nYEAR(P$13)=YEAR($B$2), MONTH(P$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(P$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(P$13)=YEAR($K$11),\n    MONTH(P$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($D$6),\nYEAR(P$13)=YEAR($D$6), MONTH(P$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(P$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(P$13)=YEAR($O$11),\n    MONTH(P$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($H$6),\nYEAR(P$13)=YEAR($H$6), MONTH(P$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(Q$13),\nDATE(YEAR(Q$13),MONTH(Q$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(Q$13),MONTH(Q$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($B$4),\nYEAR(Q$13)=YEAR($B$4), MONTH(Q$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($B$2),\nYEAR(Q$13)=YEAR($B$2), MONTH(Q$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(Q$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(Q$13)=YEAR($K$11),\n    MONTH(Q$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($D$6),\nYEAR(Q$13)=YEAR($D$6), MONTH(Q$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(Q$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(Q$13)=YEAR($O$11),\n    MONTH(Q$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($H$6),\nYEAR(Q$13)=YEAR($H$6), MONTH(Q$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(CC$13),\nDATE(YEAR(CC$13),MONTH(CC$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(CC$13),MONTH(CC$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($B$4),\nYEAR(CC$13)=YEAR($B$4), MONTH(CC$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($B$2),\nYEAR(CC$13)=YEAR($B$2), MONTH(CC$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(CC$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(CC$13)=YEAR($K$11),\n    MONTH(CC$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($D$6),\nYEAR(CC$13)=YEAR($D$6), MONTH(CC$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(CC$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(CC$13)=YEAR($O$11),\n    MONTH(CC$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($H$6),\nYEAR(CC$13)=YEAR($H$6), MONTH(CC$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},"","","","","","","",null,null,null,null,null,null,null,null,null,"UCA","In Progress"]
["Verification","Verification is estimated at 60 days for permitting and Parcel Verification. You may change the date if needed.",null,null,null,null,null,60,null,null,null,null,{"$f":"IF(K15=\"\",\"\",K15+H15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URA","Submitted to NCDOT"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=\"\",\"\",K16+H16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UPEA","Revisions"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.100000000000001,"Re-Submitted"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.2,"Approved"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Conflict","No Conflict"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["Power Pole removal","30 days is defaulted for the power pole removal. You may change the date if needed.",null,null,null,null,null,30,null,null,null,null,""]
["UBO-Transmission ","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",null,null,null,null,null,null,null,null,null,null,"UBO-Transmission ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO-Transmission ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission",null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(L33), MONTH(L33), 1)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(L35=\"\",\"\",L35+H35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K41=\"\",\"\",K41+H41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UBO- Underground","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K46=\"\",\"\",K46+H46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K48=\"\",\"\",K48+H48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K57=\"\",\"\",K57+H57)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["Utilities not in conflict",null,null,null,"Utilities not in conflict",null,null,null,null,null,null,"Utilities not in conflict"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L61=\"\",\"\",L61+H61)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["UC","Agreement information necessary","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date",null,null,"UC",null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(N83=\"\",\"\",N83+I83)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N83), MONTH(N83), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N86), MONTH(N86), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]

{"sheet":"Relo Schedule Phase 2","index":3,"n_rows":92,"n_cols":101,"rows_kept":92,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6],[4,7,4,8],[0,3,0,4],[0,5,0,6],[1,11,1,17],[2,11,3,17],[3,2,3,3],[11,15,11,87],[5,0,5,2],[5,4,5,6],[5,11,5,17],[6,0,6,1],[6,11,7,17],[9,0,9,6],[9,7,9,14],[10,1,11,6],[10,7,11,9],[10,10,11,10],[10,11,11,13],[10,14,11,14],[32,39,32,40],[32,15,32,16],[32,17,32,18],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,28],[32,29,32,30],[32,31,32,32],[32,33,32,34],[32,35,32,36],[32,37,32,38],[32,63,32,66],[32,67,32,68],[32,41,32,42],[32,43,32,44],[32,45,32,48],[32,49,32,50],[32,51,32,52],[32,53,32,54],[32,83,32,84],[32,85,32,86],[44,25,44,29],[44,45,44,49],[44,63,44,67],[44,79,44,83],[32,69,32,70],[32,71,32,72],[32,73,32,74],[32,75,32,76],[32,77,32,78],[32,79,32,82],[32,55,32,56],[32,57,32,58],[32,59,32,60],[32,61,32,62],[80,64,80,65],[80,80,80,81],[59,4,59,5],[59,11,59,12],[80,9,80,10],[80,13,80,14],[80,27,80,28],[80,47,80,48]]}
[null,"Enter in the highlighted fields",null,"NCDOT Reviewer:",null,null,null,null,null,"V2.0"]
["Let Date:",null,"TIP #:",null,"County:",null,"Division:",{"$f":"IF(F2=\"\",\"\",VLOOKUP(F2,Guidance!B85:C183,2,FALSE))","v":""},null,null,null,"Project Description:"]
[]
["PS&E Date:",null,"Utility Priority Parcels Aquired Date:"]
["Date final PUE due from PEF to DOT:",null,"Date final PUE sent to DOT:",null,null,"PUE received date compared to PUE due date:",null,{"$f":"IF(B5=\"\",\"\",\nIF(E5=B5,\"On time\",\nIF(E5>B5,\n   IF(DATEDIF(B5,E5,\"d\")<=30, DATEDIF(B5,E5,\"d\") & \" days behind schedule\", DATEDIF(B5,E5,\"m\") & \" months behind schedule\"),\n   IF(DATEDIF(E5,B5,\"d\")<=30, DATEDIF(E5,B5,\"d\") & \" days ahead of schedule\", DATEDIF(E5,B5,\"m\") & \" months ahead of schedule\")\n)))","v":""},null,{"$f":"DATEDIF(MIN(B5,E5), MAX(B5,E5), \"m\") * SIGN(E5 - B5)","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden cell do not edit",null,null,null,null,null,null,null,null,null,"Hidden"]
["SAP Utility Relocation By Others Begins Date:",null,null,null,"SAP Utility Relocation By Others Complete Date:",null,null,null,null,null,null,"Comments related to PUE and URA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(CK13), MONTH(CK13), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,"URA","Approved"]
["Moratorium Date Range",null,"Start Date:",null,"Finish Date:",null,null,null,null,null,null,"(Provide information related to PUE and URA status)"]
[]
[]
["Agreements",null,null,null,null,null,null,"Relocation"]
[null,"Utility Coordinator shall verfiy all Utilty Owners are listed and included on the Relocation Schedule (even if not in conflict) \n",null,null,null,null,null,"First Utility Relocation Start Date: ",null,null,{"$f":"IF(\n    COUNT(_xlfn._xlws.FILTER(\n        IF(L15:L89<>\"\", L15:L89, K15:K89),\n        (NOT(ISNUMBER(SEARCH(\"verification\", A15:A89)))) *\n        (((L15:L89<>\"\") + (K15:K89<>\"\")))\n    )) = 0,\n    \"Enter a relocation start date below\",\n    MIN(_xlfn._xlws.FILTER(\n        IF(L15:L89<>\"\", L15:L89, K15:K89),\n        (NOT(ISNUMBER(SEARCH(\"verification\", A15:A89)))) *\n        (((L15:L89<>\"\") + (K15:K89<>\"\")))\n    ))\n)","v":"Enter a relocation start date below"},"Final Utility Relocation Complete Date:",null,null,{"$f":"IF(COUNT(N15:N94)+COUNT(M15:M94)=0,\"Enter a relocation start date below\",MAX(IF(N15:N94<>\"\",N15:N94,M15:M94)))","v":"Enter a relocation start date below"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT($K$16:$K$89)=0,\n    \"Enter a Relocation start date\",\nIF(H6=\"\",\n    \"Enter SAP URBOC date in cell O12\",\nIF(AND(ISNUMBER(H6), ISNUMBER(O11)),\n    IF(O11 = H6,\n        \"The Relocations are scheduled to finish at the SAP URBOC\",\n        IF(O11 < H6,\n            \"The Relocation is projected to finish before the SAP URBOC\",\n            \"The Relocation is projected to be unfinished by the SAP URBOC\"\n        )\n    ),\n\"\"\n)))","v":"Enter a Relocation start date"}]
["Utility Owner","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",{"$f":"CM6","v":"1900-01-01"},{"$f":"EDATE(P13,1)","v":"1900-02-01"},{"$f":"EDATE(Q13,1)","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","1901-01-01","1901-02-01","1901-03-01","1901-04-01","1901-05-01","1901-06-01","1901-07-01","1901-08-01","1901-09-01","1901-10-01","1901-11-01","1901-12-01","1902-01-01",{"$f":"EDATE(AN13,1)","v":"1902-02-01"},{"$f":"EDATE(AO13,1)","v":"1902-03-01"},"1902-04-01","1902-05-01","1902-06-01","1902-07-01","1902-08-01","1902-09-01","1902-10-01","1902-11-01","1902-12-01","1903-01-01","1903-02-01","1903-03-01","1903-04-01","1903-05-01","1903-06-01","1903-07-01","1903-08-01","1903-09-01","1903-10-01","1903-11-01","1903-12-01","1904-01-01","1904-02-01","1904-03-01","1904-04-01","1904-05-01","1904-06-01","1904-07-01","1904-08-01","1904-09-01","1904-10-01","1904-11-01","1904-12-01","1905-01-01","1905-02-01","1905-03-01","1905-04-01","1905-05-01","1905-06-01","1905-07-01","1905-08-01","1905-09-01","1905-10-01","1905-11-01","1905-12-01","1906-01-01",{"$f":"MIN(K11,D6,K15)","v":"00:00:00"},null,null,null,null,null,null,null,null,"U&O","Not Started"]
["UBO- Aerial/ List in order of relocation (Joint use poles)","If there is a utility that is aerial and underground you should enter utilities in both categories.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(P$13),\nDATE(YEAR(P$13),MONTH(P$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(P$13),MONTH(P$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($B$4),\nYEAR(P$13)=YEAR($B$4), MONTH(P$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($B$2),\nYEAR(P$13)=YEAR($B$2), MONTH(P$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(P$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(P$13)=YEAR($K$11),\n    MONTH(P$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($D$6),\nYEAR(P$13)=YEAR($D$6), MONTH(P$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(P$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(P$13)=YEAR($O$11),\n    MONTH(P$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($H$6),\nYEAR(P$13)=YEAR($H$6), MONTH(P$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(Q$13),\nDATE(YEAR(Q$13),MONTH(Q$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(Q$13),MONTH(Q$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($B$4),\nYEAR(Q$13)=YEAR($B$4), MONTH(Q$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($B$2),\nYEAR(Q$13)=YEAR($B$2), MONTH(Q$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(Q$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(Q$13)=YEAR($K$11),\n    MONTH(Q$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($D$6),\nYEAR(Q$13)=YEAR($D$6), MONTH(Q$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(Q$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(Q$13)=YEAR($O$11),\n    MONTH(Q$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($H$6),\nYEAR(Q$13)=YEAR($H$6), MONTH(Q$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(CC$13),\nDATE(YEAR(CC$13),MONTH(CC$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(CC$13),MONTH(CC$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($B$4),\nYEAR(CC$13)=YEAR($B$4), MONTH(CC$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($B$2),\nYEAR(CC$13)=YEAR($B$2), MONTH(CC$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(CC$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(CC$13)=YEAR($K$11),\n    MONTH(CC$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($D$6),\nYEAR(CC$13)=YEAR($D$6), MONTH(CC$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(CC$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(CC$13)=YEAR($O$11),\n    MONTH(CC$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($H$6),\nYEAR(CC$13)=YEAR($H$6), MONTH(CC$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},"","","","","","","",null,null,null,null,null,null,null,null,null,"UCA","In Progress"]
["Verification","Verification is estimated at 60 days for permitting and Parcel Verification. You may change the date if needed.",null,null,null,null,null,60,null,null,null,null,{"$f":"IF(K15=\"\",\"\",K15+H15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URA","Submitted to NCDOT"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=\"\",\"\",K16+H16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UPEA","Revisions"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.100000000000001,"Re-Submitted"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.2,"Approved"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Conflict","No Conflict"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["Power Pole removal","30 days is defaulted for the power pole removal. You may change the date if needed.",null,null,null,null,null,30,null,null,null,null,""]
["UBO-Transmission ","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",null,null,null,null,null,null,null,null,null,null,"UBO-Transmission ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO-Transmission ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission",null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(L33), MONTH(L33), 1)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(L35=\"\",\"\",L35+H35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K41=\"\",\"\",K41+H41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UBO- Underground","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K46=\"\",\"\",K46+H46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K48=\"\",\"\",K48+H48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K57=\"\",\"\",K57+H57)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["Utilities not in conflict",null,null,null,"Utilities not in conflict",null,null,null,null,null,null,"Utilities not in conflict"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L61=\"\",\"\",L61+H61)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["UC","Agreement information necessary","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date",null,null,"UC",null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(N83=\"\",\"\",N83+I83)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N83), MONTH(N83), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N86), MONTH(N86), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]

{"sheet":"Example Parcels","index":4,"n_rows":110,"n_cols":32,"rows_kept":110,"cut":false,"hidden":false,"merged":[[7,5,7,8],[14,0,14,3]]}
["Legend",null,"Acquired",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acquired","Hidden"]
[null,null,"Waiting to be recorded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting to be recorded"]
[null,null,"Initial Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Contact"]
[null,null,"On Hold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Hold"]
[null,null,"Condemnation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condemnation"]
[null,null,"Filed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filed"]
[null,null,null,null,null,"Replace \"Utility Owner # \" with actual Utility Owner names"]
["Acquired","Total","% of Parcels Acquired","Acquired Date",null,"If Utility owner is on parcel select them from dropdown"]
[{"$f":"COUNTIF(G11:G110, \"Acquired\")+COUNTIF(G11:G110, \"Filed\")","v":10},{"$f":"SUMPRODUCT(--(MMULT(--(I11:X110<>\"\"),TRANSPOSE(COLUMN(I11:X11)^0))>0))","v":10},{"$f":"IF(B9=0,\"\",A9/B9)","v":1},"2027-01-01"]
[null,null,null,null,null,"Date Acquired","Status","Parcel #","Energy United","Duke Energy","Spectrum","Windstream","Electricities","AT&T","PNG","Segra","Charlotte water","Victory Comm","Lumen","MCNC","Utility owner 13","Utility owner 14","Backflow Preventer"]
[null,"EXAMPLE",null,null,null,"2026-10-05","Acquired","Parcel 001",null,null,null,null,null,null,null,"Segra"]
[null,null,null,null,null,"2026-10-15","Acquired","Parcel 002","Energy United",null,null,null,null,"AT&T",null,null,null,null,null,"MCNC",null,null,"Backflow Preventer"]
[null,"V2.0",null,null,null,"2026-10-17","Acquired","Parcel 003",null,null,null,null,null,null,null,null,"Charlotte water"]
[null,null,null,null,null,"2026-11-12","Acquired","Parcel 004",null,null,null,null,null,null,"PNG"]
["To use buttons you must have the file saved to your trusted file location, instruction on help sheet",null,null,null,null,"2026-10-05","Acquired","Parcel 005",null,null,"Spectrum",null,null,null,null,null,null,null,"Lumen"]
[null,null,null,null,null,"2026-10-05","Acquired","Parcel 006",null,null,null,"Windstream",null,"AT&T"]
[null,null,null,null,null,"2027-01-01","Acquired","Parcel 007",null,null,null,null,"Electricities","AT&T",null,null,null,"Victory Comm"]
[null,null,null,null,null,"2026-11-06","Acquired","Parcel 008",null,null,null,null,null,null,"PNG"]
[null,null,null,null,null,"2026-11-03","Acquired","Parcel 009",null,null,null,"Windstream",null,null,null,null,null,null,"Lumen"]
[null,null,null,null,null,"2026-10-05","Acquired","Parcel 010",null,null,null,null,null,null,null,null,null,"Victory Comm"]
[null,null,null,null,null,null,null,"Parcel 011"]
[null,null,null,null,null,null,null,"Parcel 012"]
[null,null,null,null,null,null,null,"Parcel 013"]
[null,null,null,null,null,null,null,"Parcel 014"]
[null,null,null,null,null,null,null,"Parcel 015"]
[null,null,null,null,null,null,null,"Parcel 016"]
[null,null,null,null,null,null,null,"Parcel 017"]
[null,null,null,null,null,null,null,"Parcel 018"]
[null,null,null,null,null,null,null,"Parcel 019"]
[null,null,null,null,null,null,null,"Parcel 020"]
[null,null,null,null,null,null,null,"Parcel 021"]
[null,null,null,null,null,null,null,"Parcel 022"]
[null,null,null,null,null,null,null,"Parcel 023"]
[null,null,null,null,null,null,null,"Parcel 024"]
[null,null,null,null,null,null,null,"Parcel 025"]
[null,null,null,null,null,null,null,"Parcel 026"]
[null,null,null,null,null,null,null,"Parcel 027"]
[null,null,null,null,null,null,null,"Parcel 028"]
[null,null,null,null,null,null,null,"Parcel 029"]
[null,null,null,null,null,null,null,"Parcel 030"]
[null,null,null,null,null,null,null,"Parcel 031"]
[null,null,null,null,null,null,null,"Parcel 032"]
[null,null,null,null,null,null,null,"Parcel 033"]
[null,null,null,null,null,null,null,"Parcel 034"]
[null,null,null,null,null,null,null,"Parcel 035"]
[null,null,null,null,null,null,null,"Parcel 036"]
[null,null,null,null,null,null,null,"Parcel 037"]
[null,null,null,null,null,null,null,"Parcel 038"]
[null,null,null,null,null,null,null,"Parcel 039"]
[null,null,null,null,null,null,null,"Parcel 040"]
[null,null,null,null,null,null,null,"Parcel 041"]
[null,null,null,null,null,null,null,"Parcel 042"]
[null,null,null,null,null,null,null,"Parcel 043"]
[null,null,null,null,null,null,null,"Parcel 044"]
[null,null,null,null,null,null,null,"Parcel 045"]
[null,null,null,null,null,null,null,"Parcel 046"]
[null,null,null,null,null,null,null,"Parcel 047"]
[null,null,null,null,null,null,null,"Parcel 048"]
[null,null,null,null,null,null,null,"Parcel 049"]
[null,null,null,null,null,null,null,"Parcel 050"]
[null,null,null,null,null,null,null,"Parcel 051"]
[null,null,null,null,null,null,null,"Parcel 052"]
[null,null,null,null,null,null,null,"Parcel 053"]
[null,null,null,null,null,null,null,"Parcel 054"]
[null,null,null,null,null,null,null,"Parcel 055"]
[null,null,null,null,null,null,null,"Parcel 056"]
[null,null,null,null,null,null,null,"Parcel 057"]
[null,null,null,null,null,null,null,"Parcel 058"]
[null,null,null,null,null,null,null,"Parcel 059"]
[null,null,null,null,null,null,null,"Parcel 060"]
[null,null,null,null,null,null,null,"Parcel 061"]
[null,null,null,null,null,null,null,"Parcel 062"]
[null,null,null,null,null,null,null,"Parcel 063"]
[null,null,null,null,null,null,null,"Parcel 064"]
[null,null,null,null,null,null,null,"Parcel 065"]
[null,null,null,null,null,null,null,"Parcel 066"]
[null,null,null,null,null,null,null,"Parcel 067"]
[null,null,null,null,null,null,null,"Parcel 068"]
[null,null,null,null,null,null,null,"Parcel 069"]
[null,null,null,null,null,null,null,"Parcel 070"]
[null,null,null,null,null,null,null,"Parcel 071"]
[null,null,null,null,null,null,null,"Parcel 072"]
[null,null,null,null,null,null,null,"Parcel 073"]
[null,null,null,null,null,null,null,"Parcel 074"]
[null,null,null,null,null,null,null,"Parcel 075"]
[null,null,null,null,null,null,null,"Parcel 076"]
[null,null,null,null,null,null,null,"Parcel 077"]
[null,null,null,null,null,null,null,"Parcel 078"]
[null,null,null,null,null,null,null,"Parcel 079"]
[null,null,null,null,null,null,null,"Parcel 080"]
[null,null,null,null,null,null,null,"Parcel 081"]
[null,null,null,null,null,null,null,"Parcel 082"]
[null,null,null,null,null,null,null,"Parcel 083"]
[null,null,null,null,null,null,null,"Parcel 084"]
[null,null,null,null,null,null,null,"Parcel 085"]
[null,null,null,null,null,null,null,"Parcel 086"]
[null,null,null,null,null,null,null,"Parcel 087"]
[null,null,null,null,null,null,null,"Parcel 088"]
[null,null,null,null,null,null,null,"Parcel 089"]
[null,null,null,null,null,null,null,"Parcel 090"]
[null,null,null,null,null,null,null,"Parcel 091"]
[null,null,null,null,null,null,null,"Parcel 092"]
[null,null,null,null,null,null,null,"Parcel 093"]
[null,null,null,null,null,null,null,"Parcel 094"]
[null,null,null,null,null,null,null,"Parcel 095"]
[null,null,null,null,null,null,null,"Parcel 096"]
[null,null,null,null,null,null,null,"Parcel 097"]
[null,null,null,null,null,null,null,"Parcel 098"]
[null,null,null,null,null,null,null,"Parcel 099"]
[null,null,null,null,null,null,null,"Parcel 100"]

{"sheet":"Example","index":5,"n_rows":92,"n_cols":101,"rows_kept":92,"cut":false,"hidden":false,"merged":[[9,0,9,6],[9,7,9,14],[0,3,0,4],[0,5,0,6],[1,11,1,17],[2,11,3,17],[3,2,3,3],[4,2,4,3],[4,5,4,6],[4,7,4,8],[5,0,5,2],[5,4,5,6],[5,11,5,17],[6,0,6,1],[6,11,7,17],[32,15,32,16],[32,17,32,18],[32,19,32,20],[10,1,11,6],[10,7,11,9],[10,10,11,10],[10,11,11,13],[10,14,11,14],[11,15,11,87],[32,45,32,48],[32,21,32,22],[32,23,32,24],[32,25,32,28],[32,29,32,30],[32,31,32,32],[32,33,32,34],[32,35,32,36],[32,37,32,38],[32,39,32,40],[32,41,32,42],[32,43,32,44],[32,73,32,74],[32,49,32,50],[32,51,32,52],[32,53,32,54],[32,55,32,56],[32,57,32,58],[32,59,32,60],[32,61,32,62],[32,63,32,66],[32,67,32,68],[32,69,32,70],[32,71,32,72],[32,75,32,76],[32,77,32,78],[32,79,32,82],[32,83,32,84],[32,85,32,86],[80,64,80,65],[80,80,80,81],[59,4,59,5],[59,11,59,12],[44,63,44,67],[44,79,44,83],[80,9,80,10],[80,13,80,14],[80,27,80,28],[80,47,80,48],[44,25,44,29],[44,45,44,49]]}
[null,"Enter in the highlighted fields",null,"NCDOT Reviewer:",null,"Dayton Martin",null,null,null,"V2.0"]
["Let Date:","2028-11-04","TIP #:","R-0001","County:","Wake","Division:",{"$f":"IF(F2=\"\",\"\",VLOOKUP(F2,Guidance!B85:C183,2,FALSE))","v":"Div 5"},null,null,null,"Project Description:"]
[null,null,null,null,null,null,null,null,null,null,null,"Replacing Bridge #204 across Century Center river"]
["PS&E Date:","2028-07-11","Utility Priority Parcels Aquired Date:",null,"2027-01-01"]
["Date final PUE due from PEF to DOT:","2025-10-16","Date final PUE sent to DOT:",null,"2025-09-03","PUE received date compared to PUE due date:",null,{"$f":"IF(B5=\"\",\"\",\nIF(E5=B5,\"On time\",\nIF(E5>B5,\n   IF(DATEDIF(B5,E5,\"d\")<=30, DATEDIF(B5,E5,\"d\") & \" days behind schedule\", DATEDIF(B5,E5,\"m\") & \" months behind schedule\"),\n   IF(DATEDIF(E5,B5,\"d\")<=30, DATEDIF(E5,B5,\"d\") & \" days ahead of schedule\", DATEDIF(E5,B5,\"m\") & \" months ahead of schedule\")\n)))","v":"1 months ahead of schedule"},null,{"$f":"DATEDIF(MIN(B5,E5), MAX(B5,E5), \"m\") * SIGN(E5 - B5)","v":-1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden cell do not edit",null,null,null,null,null,null,null,null,null,"Hidden"]
["SAP Utility Relocation By Others Begins Date:",null,null,"2026-04-01","SAP Utility Relocation By Others Complete Date:",null,null,"2028-06-01",null,null,null,"Comments related to PUE and URA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(CK13), MONTH(CK13), 1)","v":"2026-04-01"},null,null,null,null,null,null,null,null,"URA","Approved"]
["Moratorium Date Range",null,"Start Date:",null,"Finish Date:",null,null,null,null,null,null,"(Provide information related to PUE and URA status)"]
[]
[]
["Agreements",null,null,null,null,null,null,"Relocation"]
[null,"Utility Coordinator shall verfiy all Utilty Owners are listed and included on the Relocation Schedule (even if not in conflict) \n",null,null,null,null,null,"First Utility Relocation Start Date: ",null,null,{"$f":"IF(\n    COUNT(_xlfn._xlws.FILTER(\n        IF(L15:L89<>\"\", L15:L89, K15:K89),\n        (NOT(ISNUMBER(SEARCH(\"verification\", A15:A89)))) *\n        (((L15:L89<>\"\") + (K15:K89<>\"\")))\n    )) = 0,\n    \"Enter a relocation start date below\",\n    MIN(_xlfn._xlws.FILTER(\n        IF(L15:L89<>\"\", L15:L89, K15:K89),\n        (NOT(ISNUMBER(SEARCH(\"verification\", A15:A89)))) *\n        (((L15:L89<>\"\") + (K15:K89<>\"\")))\n    ))\n)","v":"2026-05-01"},"Final Utility Relocation Complete Date:",null,null,{"$f":"IF(COUNT(N15:N94)+COUNT(M15:M94)=0,\"Enter a relocation start date below\",MAX(IF(N15:N94<>\"\",N15:N94,M15:M94)))","v":"2028-03-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT($K$16:$K$89)=0,\n    \"Enter a Relocation start date\",\nIF(H6=\"\",\n    \"Enter SAP URBOC date in cell O12\",\nIF(AND(ISNUMBER(H6), ISNUMBER(O11)),\n    IF(O11 = H6,\n        \"The Relocations are scheduled to finish at the SAP URBOC\",\n        IF(O11 < H6,\n            \"The Relocation is projected to finish before the SAP URBOC\",\n            \"The Relocation is projected to be unfinished by the SAP URBOC\"\n        )\n    ),\n\"\"\n)))","v":"The Relocation is projected to finish before the SAP URBOC"}]
["Utility Owner","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",{"$f":"CM6","v":"2026-04-01"},{"$f":"EDATE(P13,1)","v":"2026-05-01"},{"$f":"EDATE(Q13,1)","v":"2026-06-01"},"2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01",{"$f":"EDATE(AN13,1)","v":"2028-05-01"},{"$f":"EDATE(AO13,1)","v":"2028-06-01"},"2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01","2029-01-01","2029-02-01","2029-03-01","2029-04-01","2029-05-01","2029-06-01","2029-07-01","2029-08-01","2029-09-01","2029-10-01","2029-11-01","2029-12-01","2030-01-01","2030-02-01","2030-03-01","2030-04-01","2030-05-01","2030-06-01","2030-07-01","2030-08-01","2030-09-01","2030-10-01","2030-11-01","2030-12-01","2031-01-01","2031-02-01","2031-03-01","2031-04-01","2031-05-01","2031-06-01","2031-07-01","2031-08-01","2031-09-01","2031-10-01","2031-11-01","2031-12-01","2032-01-01","2032-02-01","2032-03-01","2032-04-01",{"$f":"MIN(K11,D6,K15)","v":"2026-04-01"},null,null,null,null,null,null,null,null,"U&O","Not Started"]
["UBO- Aerial/ List in order of relocation (Joint use poles)","If there is a utility that is aerial and underground you should enter utilities in both categories.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(P$13),\nDATE(YEAR(P$13),MONTH(P$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(P$13),MONTH(P$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($B$4),\nYEAR(P$13)=YEAR($B$4), MONTH(P$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($B$2),\nYEAR(P$13)=YEAR($B$2), MONTH(P$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(P$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(P$13)=YEAR($K$11),\n    MONTH(P$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($D$6),\nYEAR(P$13)=YEAR($D$6), MONTH(P$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(P$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(P$13)=YEAR($O$11),\n    MONTH(P$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(P$13), ISNUMBER($H$6),\nYEAR(P$13)=YEAR($H$6), MONTH(P$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":"SAP URBOB"},{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(Q$13),\nDATE(YEAR(Q$13),MONTH(Q$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(Q$13),MONTH(Q$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($B$4),\nYEAR(Q$13)=YEAR($B$4), MONTH(Q$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($B$2),\nYEAR(Q$13)=YEAR($B$2), MONTH(Q$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(Q$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(Q$13)=YEAR($K$11),\n    MONTH(Q$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($D$6),\nYEAR(Q$13)=YEAR($D$6), MONTH(Q$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(Q$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(Q$13)=YEAR($O$11),\n    MONTH(Q$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(Q$13), ISNUMBER($H$6),\nYEAR(Q$13)=YEAR($H$6), MONTH(Q$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":"URBOB"},"","","","","","","","","","","","","","","","","","","","","","URBOC","","","SAP URBOC","PS&E","","","","LET","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"_xlfn.TEXTJOIN(\" & \", TRUE,\n\nIF(AND(ISNUMBER($D$7), ISNUMBER($F$7), ISNUMBER(CC$13),\nDATE(YEAR(CC$13),MONTH(CC$13),1) >= DATE(YEAR($D$7),MONTH($D$7),1),\nDATE(YEAR(CC$13),MONTH(CC$13),1) <= DATE(YEAR($F$7),MONTH($F$7),1)),\n\"Morato.\", \"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($B$4),\nYEAR(CC$13)=YEAR($B$4), MONTH(CC$13)=MONTH($B$4)),\n\"PS&E\", \"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($B$2),\nYEAR(CC$13)=YEAR($B$2), MONTH(CC$13)=MONTH($B$2)),\n\"LET\", \"\"),\n\n\nIF(AND(\n    ISNUMBER(CC$13),\n    ISNUMBER($K$11)\n),\nIF(AND(\n    YEAR(CC$13)=YEAR($K$11),\n    MONTH(CC$13)=MONTH($K$11)\n),\"URBOB\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($D$6),\nYEAR(CC$13)=YEAR($D$6), MONTH(CC$13)=MONTH($D$6)),\n\"SAP URBOB\", \"\"),\n\nIF(AND(\n    ISNUMBER(CC$13),\n    ISNUMBER($O$11)\n),\nIF(AND(\n    YEAR(CC$13)=YEAR($O$11),\n    MONTH(CC$13)=MONTH($O$11)\n),\"URBOC\",\"\"),\"\"),\n\nIF(AND(ISNUMBER(CC$13), ISNUMBER($H$6),\nYEAR(CC$13)=YEAR($H$6), MONTH(CC$13)=MONTH($H$6)),\n\"SAP URBOC\", \"\")\n)","v":""},"","","","","","","",null,null,null,null,null,null,null,null,null,"UCA","In Progress"]
["Verification","Verification is estimated at 60 days for permitting and Parcel Verification. You may change the date if needed.",null,null,null,null,null,60,null,null,"2026-04-01",null,{"$f":"IF(K15=\"\",\"\",K15+H15)","v":"2026-05-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URA","Submitted to NCDOT"]
["Energy United",null,"2026-01-15","2026-02-14","URA","Approved","2026-02-20",120,"2026-03-01",null,"2026-06-01",null,{"$f":"IF(K16=\"\",\"\",K16+H16)","v":"2026-09-29"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UPEA","Revisions"]
["Duke Energy",null,"2026-01-12","2026-02-14","URA","Approved","2026-02-18",60,"2026-03-02","30 days prior To Energy  United complete","2026-09-01",null,"2026-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.100000000000001,"Re-Submitted"]
["Electricities",null,"2026-01-07","2026-02-14",16.100000000000001,"In Progress",null,90,"2026-03-02","30 days prior To Duke Energy complete","2026-10-01",null,"2026-12-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.2,"Approved"]
["Spectrum","June 5 2026- Package will be ready by June 29","2026-01-04","2026-02-14",16.100000000000001,"Re-Submitted",null,150,"2026-03-02","30 days prior To Electricities  complete","2026-12-01",null,"2027-04-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Conflict","No Conflict"]
["Windstream",null,"2026-01-13","2026-02-14",16.100000000000001,"In Progress",null,60,"2026-03-02","30 days prior To Spectrum complete","2027-04-01",null,"2027-05-31"]
["AT&T",null,"2026-01-20","2026-02-14",16.100000000000001,"In Progress",null,120,"2026-03-02","30 days prior To Windstream complete","2027-05-01",null,"2027-08-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["Power Pole removal","30 days is defaulted for the power pole removal. You may change the date if needed.",null,null,null,null,null,30,null,null,"2027-09-01",null,"2027-10-01"]
["UBO-Transmission ","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",null,null,null,null,null,null,null,null,null,null,"UBO-Transmission ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO-Transmission ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission",null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(L33), MONTH(L33), 1)","v":{"$error":"#VALUE!"}}]
["Duke Transmission",null,"2025-12-12","2026-01-04","URA","Approved","2026-01-25",700,"2026-03-02",null,"2026-05-01",null,"2028-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(L35=\"\",\"\",L35+H35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K41=\"\",\"\",K41+H41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UBO- Underground","Agreement Package Comments","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date","Relocation Duration (In calendar days)","Date Utility Owner Confirmed Relocation Duration Estimate","Notification/Scheduling/Mobilization (In Days)","Utility Owner Projected Start Date","Utility Owner Actual Start Date","Utility Owner Projected Finish Date \n(Automated)","Utility Owner Actual Finish Date","Relocation Comments",null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBO- Underground",null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
["Piedmont Nat. Gas",null,"2026-01-13","2026-02-14",null,"In Progress",null,90,"2026-03-02",null,"2026-06-01",null,{"$f":"IF(K46=\"\",\"\",K46+H46)","v":"2026-08-30"}]
["Segra in Ductbank",null,"2026-01-10","2026-02-14",null,"Re-Submitted",null,120,"2026-03-02",null,"2026-06-20",null,"2026-10-18"]
["Spectrum in Ductbank",null,"2026-01-03","2026-02-14",null,"In Progress",null,115,"2026-03-02","15 days prior To Segra complete","2026-10-03",null,{"$f":"IF(K48=\"\",\"\",K48+H48)","v":"2027-01-26"}]
["Victory Comm. in DuctBank",null,"2026-01-18","2026-02-14",null,"Approved","2026-02-20",95,"2026-03-02","15 days prior To Spectrum complete","2027-01-11",null,"2027-04-16"]
["Lumen in Ductbank",null,"2026-01-06","2026-02-14",null,"In Progress",null,130,"2026-03-02","15 days prior To Victory Comm complete","2027-04-01",null,"2027-08-09"]
["MCNC in Ductbank","MCNC is revising will have it back mid march.","2026-01-24","2026-02-14",null,"Revisions",null,140,null,"15 days prior To Lumen complete","2027-07-28",null,"2027-12-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K57=\"\",\"\",K57+H57)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["Utilities not in conflict",null,null,null,"Utilities not in conflict",null,null,null,null,null,null,"Utilities not in conflict"]
["Charter",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L61=\"\",\"\",L61+H61)","v":""}]
["DOT",null,null,null,null,null,null,null,null,null,null,null,""]
["Enbridge",null,null,null,null,null,null,null,null,null,null,null,""]
["Google",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
["UC","Agreement information necessary","Date Consultant Received Agreement Package for Review","Date sent to NCDOT Utilities Lead for Review/Approval","Agreement Package Type","Agreement Package Status","Agreement Package Approval Date",null,null,"UC",null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC"]
["City of Raleigh",null,"2027-02-25","2027-03-02","UCA","Approved","2027-03-17",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(N83=\"\",\"\",N83+I83)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N83), MONTH(N83), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N86), MONTH(N86), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]

{"sheet":"Appendix","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Names","Definition"]
[null,"Relocation Duration (In calendar days)","Before the utility owner confirms the duration the coordinator will enter an estimated duration that can be changed later. Each utility owner must have a duration, preliminary or confirmed."]
[null,"PS&E (Roadway Plans to Cont & Prop)","Plans, Specifications & Estimates - Items that must be turned in 1. All Permits 2. All Agreements (UCA and U&O) 3.UBO plans, UC plans, Special Provisions, Estimates need to be turned in at PS&E, the project cannot LET without these items."]
[null,"SAP URBOB","Utility relocation By Others Begins. The official milestone date. "]
[null,"SAP URBOC","Utility relocation By Others Complete. The official milestone date. "]
[null,"Moratorium Date Range","Period of time that could possibly restrict relocation work ex. Bats, protected bodies of water, CAMA counties, Special events (US Open)."]
[null,"First Utility Relocation Start Date: ","Projected or actual first utility relocation of the project. This shows up at URBOB on the Gantt chart."]
[null,"Final Utility Relocation Complete Date:","Projected or actual final utility relocation of the project. This shows up at URBOC on the Gantt chart."]

{"sheet":"Guidance","index":7,"n_rows":183,"n_cols":3,"rows_kept":183,"cut":false,"hidden":false,"merged":[[25,0,30,10]]}
["Utility Relocation By Others – Status Schedule Process"]
["1. Complete the Status Schedule"]
["Fill out the Utility Relocation By Others Status Schedule for the TIP project, ensuring all information is current. Provide updates in Column C (Agreement Package Comments) and Column Q (Utility Owner Relocation Comments)"]
["2. Send the Schedule to NCDOT for Initial Review"]
["Email the completed schedule to the NCDOT utility lead person assigned to the project one week prior to the monthly project status meeting."]
["3. Receive NCDOT Feedback"]
["NCDOT will review the submitted schedule and provide recommended revisions."]
["4. Revise the Schedule"]
["Make all requested revisions based on NCDOT feedback."]
["5. Naming Conventions"]
["File Name: TIP # Utility Relocation By Others Today's date. Ex: R-0001 Utility Relocation By Others 5-14-2026"]
["6. Resubmit for Approval"]
["Send the revised schedule back to the NCDOT utility representative for final approval."]
["7. Upload to SharePoint"]
["Once approved, upload a copy of the final schedule to the project SharePoint site under:"]
["Utilities → Utility Type"]
["8. Send Notification Email"]
["Share the SharePoint link with the NCDOT utility lead person and the Project Manager."]
[]
[]
[null,"Macro Help below"]
[]
[]
[]
[]
["If the file has a red banner and says macros are disbaled then it is likely the location of the file saved is on your network and the network has all macros disabled, the work around would be to save as to your desktop."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trusted location"]
[]
[null,null,"First go to file, options and go to trust center. Then click trust center settings…"]
[]
[null,null,"Then go to trusted locations. At the bottom you click Add new location…"]
[null,null,"This will allow you to add a file location that excel will trust and the macros and everything will run properly."]
[null,null,"As you can see, I have added my desktop and OneDrive. When I save to another location not in the trusted locations, and I save it to an untrusted location the document does not work properly."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Alamance","Div 7"]
[null,"Alexander","Div 12"]
[null,"Alleghany","Div 11"]
[null,"Anson","Div 10"]
[null,"Ashe","Div 11"]
[null,"Avery","Div 11"]
[null,"Beaufort","Div 2"]
[null,"Bertie","Div 1"]
[null,"Bladen","Div 6"]
[null,"Brunswick","Div 3"]
[null,"Buncombe","Div 13"]
[null,"Burke","Div 13"]
[null,"Cabarrus","Div 10"]
[null,"Caldwell","Div 11"]
[null,"Camden","Div 1"]
[null,"Carteret","Div 2"]
[null,"Caswell","Div 7"]
[null,"Catawba","Div 12"]
[null,"Chatham","Div 8"]
[null,"Cherokee","Div 14"]
[null,"Chowan","Div 1"]
[null,"Clay","Div 14"]
[null,"Cleveland","Div 12"]
[null,"Columbus","Div 6"]
[null,"Craven","Div 2"]
[null,"Cumberland","Div 6"]
[null,"Currituck","Div 1"]
[null,"Dare","Div 1"]
[null,"Davidson","Div 9"]
[null,"Davie","Div 9"]
[null,"Duplin","Div 3"]
[null,"Durham","Div 5"]
[null,"Edgecombe","Div 4"]
[null,"Forsyth","Div 9"]
[null,"Franklin","Div 5"]
[null,"Gaston","Div 12"]
[null,"Gates","Div 1"]
[null,"Graham","Div 14"]
[null,"Granville","Div 5"]
[null,"Greene","Div 2"]
[null,"Guilford","Div 7"]
[null,"Halifax","Div 4"]
[null,"Harnett","Div 6"]
[null,"Haywood","Div 14"]
[null,"Henderson","Div 14"]
[null,"Hertford","Div 1"]
[null,"Hoke","Div 8"]
[null,"Hyde","Div 1"]
[null,"Iredell","Div 12"]
[null,"Jackson","Div 14"]
[null,"Johnston","Div 4"]
[null,"Jones","Div 2"]
[null,"Lee","Div 8"]
[null,"Lenoir","Div 2"]
[null,"Lincoln","Div 12"]
[null,"Macon","Div 14"]
[null,"Madison","Div 13"]
[null,"Martin","Div 1"]
[null,"McDowell","Div 13"]
[null,"Mecklenburg","Div 10"]
[null,"Mitchell","Div 13"]
[null,"Montgomery","Div 8"]
[null,"Moore","Div 8"]
[null,"Nash","Div 4"]
[null,"New Hanover","Div 3"]
[null,"Northampton","Div 1"]
[null,"Onslow","Div 3"]
[null,"Orange","Div 7"]
[null,"Pamlico","Div 2"]
[null,"Pasquotank","Div 1"]
[null,"Pender","Div 3"]
[null,"Perquimans","Div 1"]
[null,"Person","Div 5"]
[null,"Pitt","Div 2"]
[null,"Polk","Div 14"]
[null,"Randolph","Div 8"]
[null,"Richmond","Div 8"]
[null,"Robeson","Div 6"]
[null,"Rockingham","Div 7"]
[null,"Rowan","Div 9"]
[null,"Rutherford","Div 13"]
[null,"Sampson","Div 3"]
[null,"Scotland","Div 8"]
[null,"Stanly","Div 10"]
[null,"Stokes","Div 9"]
[null,"Surry","Div 11"]
[null,"Swain","Div 14"]
[null,"Transylvania","Div 14"]
[null,"Tyrrell","Div 1"]
[null,"Union","Div 10"]
[null,"Vance","Div 5"]
[null,"Wake","Div 5"]
[null,"Warren","Div 5"]
[null,"Washington","Div 1"]
[null,"Watauga","Div 11"]
[null,"Wayne","Div 4"]
[null,"Wilkes","Div 11"]
[null,"Wilson","Div 4"]
[null,"Yadkin","Div 11"]